select
from
where
group by
having
order by
执行顺序:
1.from
把执行操作的表放入内存
2.where
选取元组
3.group by
元组分组
4.having
选择分组
5.select
投影
6.order by
排序输出
select
from
where
group by
having
order by
执行顺序:
1.from
把执行操作的表放入内存
2.where
选取元组
3.group by
元组分组
4.having
选择分组
5.select
投影
6.order by
排序输出