SQL 语句的执行顺序

SQL 语句的执行顺序跟其语句的语法顺序并不一致

一般而言

SQL 语句的语法顺序是：

1. SELECT[DISTINCT]
2. FROM
3. WHERE
4. GROUP BY
5. HAVING
6. UNION
7. ORDER BY

其执行顺序为：

1. FROM
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. DISTINCT
7. UNION
8. ORDER BY