完整SQL语句

SELECT DISTINCT <column_list>
FROM <table_name_1>
<join_type> JOIN <table_name_2> ON <join_condition>
WHERE <where_codition>
GROUP BY <group_by_list>
HAVING <having_condition>
ORDER BY <order_by_condition>
LIMIT {[offset,] row_count | row_count OFFSET offset_num}

SQL 执行顺序

1. FROM
2. ON
3. JOIN
4. WHERE
5. GROUP BY
6. SELECT DISTINCT
7. ORDER BY
8. LIMIT {[offset,] row_count | row_count OFFSET offset_num}