MySql的select语句的关键字一般顺序

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}]