1 2 3 4 5 6 7 8 9 | SELECT CONCAT(TRIM(r_numbering) , TRIM(TO_CHAR(r_cnt ))) FROM ( SELECT R_NUMBERING, R_CNT, ROW_NUMBER() OVER( ORDER BY R_CNT DESC ) AS NUM FROM IF_RMS_ERP_PART_INPUT_INFO WHERE TM_NO = 'EABUHU282789' AND R_CLASS <> '2' --취소가 안된 것. ) WHERE NUM = 1; |