Monday, May 10, 2010

Order in which Query got executed by SQL Server

Here is the know fact,

 

The way you write query is never executed in same order, so today I am post the order in which query got executed by SQL Server

 

  1. FROM
  2. JOINS
  3. WHERE CLAUSE
  4. GROUP BY
  5. HAVING
  6. SELECT
  7. DISTINCT
  8. ORDER BY
  9. TOP

 

 

No comments:

Post a Comment