I have table with columns as name, deptno and salary.
I need to get the names which has maximum salary in their deptmenets.
I could able to find maximum salaries in each department using
select depno, max(sal) from emp GROUP BY deptno;
But how to get correspodning names?
Thanks
Pawan
SCJP 5.0, SCWCD 1.4