Order of the clauses

The required order of the clauses is as follows:


  1. SELECT list expressions
  2. FROM table
  3. WHERE condition for the selection of rows
  4. HAVING condition for selection of groups
  5. ORDER BY expression
  6. ;


No comments: