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 ;