What's the execute order of the different parts of a SQL select statement?

Question

Hi guys,

What's the execute order of the different parts of a SQL select statement? Such as
distinct
from
order by
group by
having
multiline function(count, avg, max, min...)
top(sql server) or limit(mysql)
other parts

Does the different databases have the same execution order? Great thanks.

Answer 1

Have a look at

SQL SERVER – Logical Query Processing Phases – Order of Statement Execution

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

Also, for some good info see Logical Query Processing