写法顺序:select–from–where–group by–having–order by
执行顺序:from–where–group by–having–select–order by 就是select要放后面,如果有order by,则order by放最后,因为order by 是对结果进行排序
一、sql执行顺序
(1)from
(3) join
(2) on
(4) where
(5)group by(开始使用select中的别名,后面的语句中都可以使用)
(6) avg,sum…
(7)having
(8) select
(9) distinct
(10) order by