(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 condition>
(10)ORDER BY <order_by_list>
(11)LIMIT <limit_number>
转载于:https://my.oschina.net/johny/blog/99607