Home » Tutorials » SQL Query – Order of execution

SQL Query – Order of execution

Our Categories

Blog Stats

  • 32,852 hits

Calendar

April 2013
M T W T F S S
« Mar   May »
1234567
891011121314
15161718192021
22232425262728
2930  

Order of execution

Please visit SQLVERSITY.COM for more details.

When you execute a SQL Query, it will be executed in the following sequence.

FROM

ON

JOIN

WHERE

GROUP BY

HAVING

SELECT

DISTINCT

ORDER BY

TOP

Advertisements

1 Comment

  1. […] look like if you could see your SQL query constructed in real time. I did not, however, mention the order in which SQL Server executes your query¬†(I couldn’t find this information from Books Online, so the aforementioned source will […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: