Sequence of Sql QueryExecution

Step 1: FROM clause - Identify the objects

Step 2: FROM clause Joins - Identified objects are joined based on the conditions (filtering data)

Step 3: WHERE clause - Where condition is applied which again filters data based on the conditions applied.

Step 4: GROUP BY clause - Records are grouped based on the condition.

Step 5: HAVING clause - Having conditions are applied to filter the grouped data.

Step 6: SELECT clause - Mentions coloumns are selected

Step 7: ORDER BY clause - Selected columns are finally sorted based on the order by condition and displayed to user.

or you check this link

http://ntsrikanth.blogspot.in/2007/11/sql-query-order-of-execution.html

http://blog.sqlauthority.com/2009/04/06/sql-server-logical-query-processing-phases-order-of-statement-execution/

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
Accepted answer
hi,

i found this in a link.

in order:

FROM & JOINs determine & filter rows
WHERE more filters on the rows
GROUP BY combines those rows into groups
HAVING filters groups
SELECT clause
ORDER BY arranges the remaining rows/groups
Sanjeeb Lenka13y ago
Step 1: FROM clause - Identify the objects

Step 2: FROM clause Joins - Identified objects are joined based on the conditions (filtering data)

Step 3: WHERE clause - Where condition is applied which again filters data based on the conditions applied.

Step 4: GROUP BY clause - Records are grouped based on the condition.

Step 5: HAVING clause - Having conditions are applied to filter the grouped data.

Step 6: SELECT clause - Mentions coloumns are selected

Step 7: ORDER BY clause - Selected columns are finally sorted based on the order by condition and displayed to user.

or you check this link

http://ntsrikanth.blogspot.in/2007/11/sql-query-order-of-execution.html

http://blog.sqlauthority.com/2009/04/06/sql-server-logical-query-processing-phases-order-of-statement-execution/
Abhineet Srivastava13y ago
Thanks Sanjeeb :)