废话不多说🙅🏻♀️,直接上干货!
(8) SELECT (9)DISTINCT<Select_list> case when…end as [new column]... (1) FROM <left_table> (3) <join_type> JOIN <right_table> (2) ON<join_condition> (4) WHERE<where_condition> (5) GROUP BY<group_by_list> (6) WITH {CUBE|ROLLUP} (7) HAVING<having_condtion> (10) ORDER BY<order_by_list> (11) LIMIT<limit_number>