Answer Posted / Abhishek Swaroop
The CUBE operator in SQL creates a cross product of all possible groupings of columns in a query's result set, including all single-column groupings. It is similar to the GROUP BY operator but generates more rows by aggregating data across multiple dimensions. The resulting table has one row for each unique combination of grouped values.nnFor example:n```sqlnSELECT department, job_title, COUNT(*) FROM employees GROUP BY CUBE (department, job_title);```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
