- 书写顺序
select
from
join on
where
group by
order by
having
limit
- 执行顺序
from -> join on -> where -> group by -> select -> having -> order by -> limit
注:- select之后都可以使用别名
- 子查询先走
- 需要对查询后的结果进行处理,需要使用子查询。
select
from
join on
where
group by
order by
having
limit