How to display the 3rd highest salary in the employee table?

SELECT *
  FROM (SELECT ename, sal, DENSE_RANK () OVER (ORDER BY sal DESC) r
          FROM emp)
 WHERE r = 3