728x90
※ ORACLE 사용방법
-
SELECT A, B, sum(C) FROM TABLE GROUP BY ROLLUP(A, B);
※ MySQL 사용방법
-
SELECT A, B, sum(C) FROM TABLE GROUP BY A, B WITH ROLLUP;
728x90
Mysql / MariaDB] Mysql에서 ROLLUP사용방법
2020. 8. 31. 15:41
※ ORACLE 사용방법
SELECT A, B, sum(C) FROM TABLE GROUP BY ROLLUP(A, B);
※ MySQL 사용방법
SELECT A, B, sum(C) FROM TABLE GROUP BY A, B WITH ROLLUP;