Multiple choice technology databases

Which operators can be used to produce summary totals in the result sets of SQL 2008.

  1. GROUPING

  2. WITH ROLL UP

  3. WITH CUBE

  4. WITH SUMMARY
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

WITH ROLLUP generates subtotals and grand totals based on the grouping hierarchy. WITH CUBE generates all possible combinations of subtotals across grouping columns. GROUPING and WITH SUMMARY are not valid SQL 2008 syntax for producing totals.

Keep practicing — related questions