Database

[ORACLE]ROW_NUMBER 순서

애플자라 2018. 7. 3. 08:29
반응형
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

 

반응형