SELECT
select_expr,…
FROM table_reference
[WHERE where_definition]
[GROUP BY {col_name|expr|position}]
[HAVING where_definition]
[ORDER BY{col_name|expr|positon}[DESC|ASC],…]
[LIMIT {[offset] row_count}]
原文：https://www.cnblogs.com/briskzou/p/12083423.html