7.19 JOIN
-- 타입변환, MULTI-ROW FUNCTION -- 그룹화와 관련된 함수 -- ROLLUP 함수 -- SELECT -- FROM -- WHERE -- GROUP BY ROLLUP (그룹화할 열 지정) SELECT DEPTNO, JOB, COUNT(*), MAX(SAL), SUM(SAL), AVG(SAL) FROM EMP GROUP BY DEPTNO, JOB ORDER BY DEPTNO, JOB; SELECT DEPTNO, JOB, COUNT(*), MAX(SAL), SUM(SAL), AVG(SAL) FROM EMP GROUP BY ROLLUP(DEPTNO, JOB) ORDER BY DEPTNO, JOB; -- CUBE 함수 -- SELECT -- FROM -- WHERE -- GROUP BY CUBE..
