如何找出EMP表里面SALARY第N高的employee

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
例如:-
输入&N的值为2 则输出结果为：
SAL
———
3700