ORACLE 取第二条数据并进行拼接查询

sql: 

 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 ;