[SQL/오라클] ROLLUP, CUBE, GROUPING SETS

데이터를 ROLLUP, CUBE, GROUPING SET으로 출력

 

select * from sqld_34_20; 

 

 

• ROLLUP

  select id, dept_nm, sum(salary)
    from sqld_34_20
group by rollup(id, dept_nm);

 

• CUBE

  select id, dept_nm, sum(salary)
    from sqld_34_20
group by cube(id, dept_nm);

 

 

• GROUPING SETS

  select id, dept_nm, sum(salary)
    from sqld_34_20
group by grouping sets(id, dept_nm);

 

 

---

  select id, dept_nm, sum(salary)
    from sqld_34_20
group by grouping sets((id, dept_nm));

 

  select id, dept_nm, sum(salary)
    from sqld_34_20
group by grouping sets(id, dept_nm, ());