SQL语句的编写顺序和执行加载顺序
1.编写顺序
SELECT DISTINCT <select_list>
FROM <left_table>
<join_type> JOIN <right_table> ON <join_condition>
WHERE <where_condition>
GROUP BY <group_by_list>
HAVING <having_condition>
ORDER BY <order_by_condition>
LIMIT <limit_number>
2.执行加载顺序
FROM
ON
JOIN
WHERE
GROUP BY
HAVING
SELECT DISTINCT
ORDER BY
LIMIT
如图所示: