Sql执行顺序

SQL执行顺序

书写顺序

SELECT -> DISTINCT -> TOP -> FROM -> JOIN -> ON -> WHERE -> GROUP BY -> HAVING -> ORDER BY

执行顺序

FROM -> ON -> JOIN -> WHERE -> GROUP BY -> SUM、COUNT、MAX、AVG -> HAVING -> SELECT -> DISTINCT -> ORDER BY -> TOP