29 December 2013

Order of Query execution in sql server

Some times we want to know about query execution order, the same question has got from my student when I'm giving seminar about SQL. It is very simple.


1.  FROM clause 
2.  WHERE clause 
3.  GROUP BY clause 
4.  HAVING clause 
5.  SELECT clause 
6.  ORDER BY clause

No comments:

Post a Comment