SELECT CONCAT(CLDR_YY, CLDR_MM) AS "월별", COUNT(*) AS "영업일" FROM ( SELECT DISTINCT CLDR_YY, CLDR_MM, CLDR_DD, CLDR_DATE, CLDR_WEEK FROM ATN_CALENDAR WHERE HLDY_YN !='Y' -- 영업일 AND CLDR_YY ='2022' )X GROUP BY CONCAT(CLDR_YY, CLDR_MM)

1. MariaDB 설치 #yum install -y mariadb-server 2. MariaDB 실행 방법 - 시스템 부팅 시 자동 시작 #systemctl enable mariadb - mariadb 실행 #systemctl start mariadb - mariadb 상태 확인 #systemctl status mariadb 3. Mariadb 접속 방법 - root 계정 비밀번호 생성 #mysqladmin password mypass - 비밀번호 변경 방법( 3가지 ) 1. #mysqladmin -u root password 새비밀번호 * UPDATE 이용 2. #mysql -u root mypass -------------- >UPDATE user SET password=password('새비밀번..

SELECT ym, MIN(CASE dw WHEN 1 THEN LPAD(d,2,'0') END) Sun, MIN(CASE dw WHEN 2 THEN LPAD(d,2,'0') END) Mon, MIN(CASE dw WHEN 3 THEN LPAD(d,2,'0') END) Tue, MIN(CASE dw WHEN 4 THEN LPAD(d,2,'0') END) Wed, MIN(CASE dw WHEN 5 THEN LPAD(d,2,'0') END) Thu, MIN(CASE dw WHEN 6 THEN LPAD(d,2,'0') END) Fri, MIN(CASE dw WHEN 7 THEN LPAD(d,2,'0') END) Sat FROM (SELECT date_format(dt, '%Y%m') ym, Week(dt) w,..

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

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 TO_CHAR (REG_DATE, 'YYYY-MM-DD') AS "접수일", COUNT (1) "접수건수", SUM (COUNT (1)) OVER (ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')) "누적접수건수" FROM N_BOARD_EVENT GROUP BY TO_CHAR (REG_DATE, 'YYYY-MM-DD') ORDER BY TO_CHAR (REG_DATE, 'YYYY-MM-DD')

EDIT EM_MMT_LOG_201806 WHERE TRAN_ETC2='MASS' AND REGEXP_LIKE(TRAN_ETC1, '2018060800001|2018061100001|2018061100002') --AND TRAN_ETC1 (LIKE '%2018060800001%' or LIKE '%2018061100001%' or LIKE '%2018061100002%')

SELECT '신청: '||TOTAL||'건(전체), '||P_TYPE||'건(PC), '||M_TYPE||'건(모바일)' AS EVENT_MFROM(SELECT COUNT (1) AS TOTAL, COUNT (DECODE (TYPE, 'P', 'P')) AS P_TYPE, COUNT (DECODE (TYPE, 'M', 'M')) AS M_TYPE FROM N_BOARD_EVENT)

SELECT GROUP_NAME, REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_01),',',' '),'(Meeting)','') AS DATE_01, REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_02),',',' '),'(Meeting)','') AS DATE_02, REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_03),',',' '),'(Meeting)','') AS DATE_03, REPLACE(REPLACE(WMSYS.WM_CONCAT(DISTINCT MARKETING_DATE_04),',',' '),'(Meeting)','') AS ..

-- 2건이상 데이터 SELECT MAX(ID) AS ID, MAX(TIMS_DATE) AS TIMS_DATE, MAX(FUND_CODE) AS FUND_CODE, COUNT(*) AS CNT FROM IFT_FUND_STANDARD_MODIFY WHERE FUND_CODE ='01032' GROUP BY TIMS_DATE||FUND_CODE HAVING COUNT(*) > 1 -- 2건이상 데이터중 과거 데이터 삭제 DELETE -- SELECT꼭 해보고 날려버린다 FROM IFT_FUND_STANDARD_MODIFY WHERE TIMS_DATE||FUND_CODE IN ( SELECT TIMS_DATE||FUND_CODE FROM IFT_FUND_STANDARD_MODIFY WHERE FUND_COD..