1.count函数
select count(comm) from scott.emp;
返回列值不为空的信息统计
2.avg
select avg(NVL(comm,0)) from scott.emp;
3.sum
4.min与max
5.group by
select job,avg(sal) from scott.emp group by job order by avg(sal) desc;
查询工作上平均工作比较高地工作。
6.having
select job,avg(sal) from scott.emp group by job having avg(sal)>1500;
select job,avg(sal) from scott.emp group by job having avg(sal)>1500 order by 2;
select count(comm) from scott.emp;
返回列值不为空的信息统计
2.avg
select avg(NVL(comm,0)) from scott.emp;
3.sum
4.min与max
5.group by
select job,avg(sal) from scott.emp group by job order by avg(sal) desc;
查询工作上平均工作比较高地工作。
6.having
select job,avg(sal) from scott.emp group by job having avg(sal)>1500;
select job,avg(sal) from scott.emp group by job having avg(sal)>1500 order by 2;