SELECT语法

SELECT用于返回表和用户定义的函数中的行，具体语法如下

[ WITH with_subquery [, ...] ]
SELECT
[ [ ALL | DISTINCT ] |  select_expr [ AS output_name ] [, ...] ] 
[ FROM table_reference [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition ]
[ { UNION | ALL | INTERSECT | EXCEPT | MINUS } query ]
[ ORDER BY expression
[ ASC | DESC ]
[ LIMIT { number | ALL } ]

本节包含以下几个部分：

• WITH子句

• MATCH…AGAINST

• GROUP BY

• HAVING

• UNION、INTERSECT、 EXCEPT

• ORDER BY

• LIMIT

• JOIN

• 子查询