Thursday 20 October 2011

SQL Processing order

The correct order of the Logical 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