聚合:max/min/sum/avg
统计部门编号有多少员工为10
select count(1) from emp where deptno=10;
select max(sal),min(sal),sum(sal),avg(sal) from emp;
聚合:max/min/sum/avg
统计部门编号有多少员工为10
select count(1) from emp where deptno=10;
select max(sal),min(sal),sum(sal),avg(sal) from emp;