select语句

查询语句的完整语句：

select 去重选项 字段列表 [as 字段别名] from 数据源（【join类型】join  表名 on（条件）） [where子句] [group by 子句] [having子句] [order by 子句] [limit子句];

查询语句的执行顺序：

(1) FROM <left_table>

(2) ON <join_condition>

(3) <join_type> JOIN <right_table>

(4) WHERE <where_condition>

(5) GROUP BY <group_by_list>

(6) WITH {CUBE | ROLLUP}

(7) HAVING <having_condition>

(8) SELECT

(9) DISTINCT

(9) ORDER BY <order_by_list>

(10) <TOP_specification> <select_list>