Oracle EBS SQL :Ranking of Salary Dept wise

 HOw to query raking of salaries department wise?

SELECT empno,
       deptno,
       sal,
       RANK () OVER (PARTITION BY deptno ORDER BY sal DESC) AS ranking
  FROM emp