写法顺序:select--from--where--group by--having--order by
执行顺序:from--where--group by--having--select--order by
就是select要放后面,如果有order by,则order by放最后,因为order by 是对结果进行排序
SQL知识点-更新ing
原文:https://www.cnblogs.com/Vapriest/p/13019418.html