How the SQL Query Executes in a Order

Order of the SQL Query processing phases.

The correct order of the SQL Query Processing Phases is as follows:

1. FROM
2. ON
3. OUTER
4. WHERE
5. GROUP BY
6. CUBE/ROLLUP
7. HAVING
8. SELECT
9. DISTINCT
10. TOP
11. ORDER BY