select k.SAL from (
select SAL,rownum rn from (select SAL
from SCOTT.EMP
where MGR = 7698
order by SAL desc)
) k
where rn = 2
rownum就是在查询结果中新增了一行num
SAL RN
--------- ----------
1600.00 1
1500.00 2
1250.00 3
1250.00 4
950.00 5
