sql执行顺序

select 执行顺序

1.from 第一步从from
2.on
3.join
4.where
5.group by 从这步开始可以使用别名
6.avg
7.with
8.having
9.select
10order by
11limit/top

sql 书写顺序
1.select
2.top
3.from
4.join
5.on
6.where
7.grouop by
8.having
9.order by