SELECT NAME2 AS "부서", NAME4 AS "이름", NAME5 AS "직위", (SELECT NAME1 FROM TEST.PERSON ZZ WHERE NAME5=XX.NAME4) AS "순서", SUM_HH, SUM_MM, SUM_HH*60 AS SUM_HH_60, SUM_MM AS SUM_MM_60, SUM_HH*60 + SUM_MM AS SUM_FINAL, (SUM_HH*60 + SUM_MM)/60 AS SUM_F_HH, ((SUM_HH*60 + SUM_MM)/60)/24 AS SUM_F_DAY FROM ( SELECT NAME2, # "부서" NAME4, # "이름" NAME5, # "직위" NAME25, LPAD(NAME25,7,'00h '), SUBSTR(LPAD(NAME25,7,..

EDIT N_FUND_GOOD A WHERE DEL_YN = 'N' AND USE_YN = 'Y' ORDER BY DECODE(GOOD_TYPE,'FD101',1,'FD102',2,'FD103',3,'FD109',4,'FD104',5) , FUND_CODE ASC

1.  가.     (1)        (가)            1)                가)                  ①                     ㉮ 출처: https://applejara.tistory.com/628 [애플자라] 문서작성 번호순서1. 가.     1)        가)            (1)               (가)                  ①                     ㉮               ..applejara.tistory.com

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