Returns GROUPING results as a bitmask.
Syntax
GROUPING_ID(expr, ...)Example
Enter values below to update the example in real time.
department_id→job_id→salary→grp_id→employees→SELECT department_id, job_id,
SUM(salary),
GROUPING_ID(department_id, job_id) AS grp_id
FROM employees
GROUP BY CUBE (department_id, job_id);