ROW_NUMBER

SELECT ROW_NUMBER() OVER (ORDER BY NAME ASC) AS EMS_M_ID, NAME AS EMS_M_NAME, TRIM(REPLACE(MOBILE,'-','')) AS EMS_M_PHONE FROM APLUSORA.TEMP_N_BOARD_EVENT ORDER BY NAME ASC

SELECT ROW_NUMBER () OVER (ORDER BY NAME ASC) EMS_M_ID, NAME, EMAIL FROM 테이블명

SELECT A.POST_ID I_POST_ID, A.NAME AS I_NAME, A.PHONE1 I_R_PHONE1, A.PHONE2 I_R_PHONE2, A.PHONE3 I_R_PHONE3, NVL (B.GUBUN, '신규') AS GUBUN1, A.REGISTER_DT I_REGISTER_DT, A.GUBUN GUBUN, A.EVENT_YN, ROW_NUMBER () OVER (ORDER BY REGISTER_DT DESC) RNM, A.CELLPHONE FROM EVENT A, APLUS_V_CUSTOMER_CELLPHONE B AND A.CELLPHONE = B.CELLPHONE(+) AND A.NAME = B.CUSTOMER_NM(+) ORDER BY A.REGISTER_DT DESC A테이블..

SELECT B.* FROM ( SELECT ROW_NUMBER() OVER(ORDER BY DATE DESC) RNUM,A.* FROM TABLE A ) B WHERE RNUM BETWEEN 1 AND 50