top 5th Salary of every department

SELECT * FROM (

SELECT EMP_ID, DEPT_ID, SALARY, NAME

,RANK() OVER (PARTITION BY DEPT_ID ORDER BY SALARY DESC) AS RANKID

FROM EMP) A WHERE RANKID = 5