ROLLUP/CUBE 집계 여부를 반환합니다.
문법
GROUPING(expr)예제
아래 값을 입력하면 예제에 즉시 반영됩니다.
department_id→job_id→salary→total→grp_dept→employees→SELECT department_id, job_id,
SUM(salary) AS total,
GROUPING(department_id) AS grp_dept
FROM employees
GROUP BY ROLLUP (department_id, job_id);