SQL44 MYSQL 날짜 계산 함수 DATE_SUB DATE_ADD SELECT DATE_SUB(DATE_YMD, INTERVAL 1 DAY), -- 빼기 DATE_ADD(DATE_YMD, INTERVAL 1 DAY) -- 더하기 FROM TABLE DATE_ADD(컬럼명, INTERVAL 1 기준) 2024. 4. 4. MySQL IN 두 컬럼 이상 비교 SELECT * FROM TAB1 WHERE (NAME, AGE) IN (SELECT DISTINCT NAME, MAX(AGE) FROM TAB1 GROUP BY JOB) -- ORDER BY JOB WHERE (조건1, 조건2) IN (비교조건1, 비교조건2) 2024. 4. 3. VIEW CREATE VIEW TEST_VIEW AS SELECT EXTRACT(YEAR FROM ORDER_DATE) YYYY, SUM(SALES_AMT) TOT_AMT FROM SALES GROUP BY EXTRACT(YEAR FROM ORDER_DATE) ; /* 확인 */ SELECT * FROM TEST_VIEW; 2024. 4. 2. NTILE PARTITION BY SELECT CASE WHEN RN2 = 1 THEN 'A조' WHEN RN2 = 2 THEN 'B조' WHEN RN2 = 3 THEN 'C조' END AS NEW_TEAM , T2.* FROM (SELECT NTILE(3) OVER (PARTITION BY TEAM_NM ORDER BY DBMS_RANDOM.RANDOM) AS RN2, TEAM_NM, SAWON_CODE,SAWON_NAME,INSERT_DATE FROM L_TAB WHERE TO_CHAR(INSERT_DATE,'YYYYMM') = TO_CHAR(ADD_MONTHS(SYSDATE,-1),'YYYYMM') ORDER BY RN2, TEAM_NM ) T2 기존 팀 [TEAM_NM] 에서 팀별 3명 씩 나누어 새로운 팀 [NEW_TEAM] 에.. 2024. 4. 2. 이전 1 2 3 4 5 6 7 ··· 11 다음
