Sunday, 23 February 2014

In what sequence SQL statement are processed?

The clauses of the select are processed in the following sequence
  1. FROM clause
  2. WHERE clause
  3. GROUP BY clause
  4. HAVING clause
  5. SELECT clause
  6. ORDER BY clause
  7. TOP clause

No comments:

Post a Comment

Note: only a member of this blog may post a comment.