高级查询的6大关键字(单表)
select 查询结果集
from 数据源
where 条件语句块
group by 分组
having 和groupby绑定使用,对分组数据,再次进行条件筛选
order by 排序
书写顺序:
select-->from-->where-->groupby-->having-->order by
例子:select * from table where ... group by * having ...order by *;
执行顺序
from-->where-->groupby-->having-->select-->order by
注意:以上仅针对oracle,其他不清楚。