[Solved] Which of the following is the correct syntax to use CUBE in a PostgreSQL query? — Ans: SELECT col1, col2, SUM(sales) FROM table GROUP BY CUBE(col1, col2); | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Which of the following is the correct syntax to use CUBE in a PostgreSQL query?

ASELECT col1, col2, SUM(sales) FROM table CUBE BY (col1, col2);

BSELECT col1, col2, SUM(sales) FROM table GROUP BY CUBE col1, col2;

CSELECT col1, col2, SUM(sales) FROM table GROUP BY ROLLUP(col1, col2);

DSELECT col1, col2, SUM(sales) FROM table GROUP BY CUBE(col1, col2);

Step-by-Step Solution

Solution:

Step 1: Recall correct GROUP BY syntax with CUBE
The correct syntax is GROUP BY CUBE(col1, col2) with parentheses around columns.
Step 2: Identify incorrect options
SELECT col1, col2, SUM(sales) FROM table CUBE BY (col1, col2); uses invalid 'CUBE BY', C uses ROLLUP, D misses parentheses.
Final Answer:
SELECT col1, col2, SUM(sales) FROM table GROUP BY CUBE(col1, col2); -> Option D
Quick Check:
GROUP BY CUBE(columns) syntax [OK]

Quick Trick: Use GROUP BY CUBE(col1, col2) with parentheses [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax to use CUBE in a PostgreSQL query?