oracle排序后取第二条数据
select * from (
select rownum rn,
KHND_DM || ' 年考核结果 ' || (select codedesc from TY_CODETERM where CODETYPEID = 'CODE_CheckConclusionType' AND CODETERMID = KHDC_DM) KHDC_DM
from (
SELECT * FROM TY_EMP_R0183 WHERE EMPID = '59992277' ORDER BY KHND_DM DESC
)
) k where rn = 2 ;