Oracle SQL Forum
Could you please help me to get the highest salary of each department. If multiple employees having the highest salary in the same department then I need the get oldest employee details(who joined first in the company).
Thanks in advance!
select * from (select ename,deptno,sal,hiredate,dense_rank() over(partition by deptno order by sal desc,hiredate asc) rn from emp)where rn=1;
SELECT DEPARTMENT_ID,MAX(SALARY) FROM EMPLOYEES
GROUP BY DEPARTMENT_ID;
Sign up for STechies
Ask Question From Our Experts