Mysql数据库轻松学07—select语句书写顺序及执行顺序

1、select语句书写顺序

子句说明select要返回的列或表达式from从中检索数据的表where行级过滤group by分组说明having组级过滤order by输出排序顺序

select —> from —> where —> group by —> having —> order by

2、select语句执行顺序

from —> where —> group by —> having —> select —> order by —> limit