SQL语句语法顺序

查询语句语法顺序：

查询语句书写顺序：SELECT - FROM - WHERE - GROUP BY- HAVING - ORDER BY - LIMIT

查询语句执行顺序：FROM - WHERE -GROUP BY - HAVING - SELECT - ORDER BY - LIMIT  

增加内容:

查询语句语法：
SELECT [ALL | DISTINCT] select_expr, select_expr, ...
  FROM table_reference       -- 从什么表查
  [WHERE where_condition]   -- 过滤
  [GROUP BY col_list]        -- 分组查询
   [HAVING col_list]          -- 分组后过滤
  [ORDER BY col_list]        -- 排序    统称为hive中4个by
  [CLUSTER BY col_list
    | [DISTRIBUTE BY col_list] [SORT BY col_list]
  ]
 [LIMIT number]                -- 限制输出的行数