i generally read everywhere that SQL has no order of execution and it depends on the optimizer the best order possible is followed but we generally follow some order while evaluating the sql query i came across this order and i also find it logically right
1. FROM
2. ON
3. OUTER
4. WHERE
5. GROUP BY
6. CUBE | ROLLUP
7. HAVING
8. SELECT
9. DISTINCT
10 ORDER BY
11. TOP
can anyone throw more light on this