执行顺序: from --> where --> group by --> having --> select --> order by --> limit 书写顺序: select 字段,函数,子查询from 表where 定位数据行条件【关系运算/逻辑运算/特殊运算符】group by 分组字段1,分组字段2having 对临时表进行删除判断条件order by 排序字段1,排序字段2limit 从起始行位置开始向下截取行数