30 - list the salary is higher than in the department employee name and salary of all employees salary, department name, department number
The select e.e name, e.s al, d.d name, en
The from emp e, d dept, (select count (ename) en the from emp where sal & gt;
(select Max (sal) from emp where deptno='30' group by deptno) group by deptno)
Where e.d eptno=d.d eptno
And sal & gt;
(select Max (sal) from emp where deptno='30' group by deptno)
The duplicate values go out ah ah