一、sql执行顺序
(1)from
(3) join
(2) on
(4) where
(5)group by
(6) avg,sum....
(7)having
(8) select
(9) distinct
(1)from
(3) join
(2) on
(4) where
(5)group by
(6) avg,sum....
(7)having
(8) select
(9) distinct
(10) order by
只有orderby可以使用select中的别名