After insert trigger and select

Hi.

If I have after insert trigger on some table which updates some data in 
that same table, will be the select statement from some other client 
executed after all statements in that trigger?

Thank you and kind regards,

Rok