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

2014-11-23 20:13:14 · 作者: · 浏览: 8

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