호로록개발TIL 호로록개발TIL

CUBE

• Day5

  SQL 2021. 7. 17. 12:24

  ROllUP-집계함수 ">//ROLLUP = UNION사용 select list1, list2, sum(sal) from emp group by rollup(list1, list2) ---------------------------------------- //Union사용 select list1, list2, sum(sal) from emp group by rollup(list1, list2) UNION select list1, list2, sum(sal) from emp group by rollup(list1, null) UNION select list1, list2, sum(sal) from emp group by rollup(null, null) CUBE-집계함수 //CUBE 함수 select li..

  Read More