Oracle SQL Forum
Could you guys please let me know that how to wirte a query to get 4th highest salary for each department?
kindly share your valuable views here, so i can proceed further.
Thanks in advance.
select * FROM ( select EmployeeID, Salary deptno ,denserank() over (order by deptno,Salary (DESC) r from Employee ) WHERE r=4
Sign up for STechies