Question

在oracle中emp表:显示部门人数大于10的每个部门的最高工资?怎么写

Answer 1

select max(sal+nvl(comm,0)),deptno
from emp
where deptno in(select deptno from emp group by deptno having count(*)>10)
group by deptno;

或是直接
select max(sal+nvl(comm,0)),deptno
from emp
group by deptno
having count(deptno)>10;

（ps:emp表中应该没有哪个部门人数大于10吧！）

Answer 2

select dept.Dept_name,Max(emp.salary) from employee emp,department dept
where dept.dept.id=emp.dept.id
and dept.empcount>10
group by dept.dept_name