SQL语句执行顺序 博客分类： 数据库 SQL执行顺序SQL语句

下面是SELECT语句的逻辑执行顺序：

FROM

ON

JOIN

WHERE

GROUP BY

WITH CUBE or WITH ROLLUP

HAVING

SELECT

DISTINCT

ORDER BY

TOP