Question
What is the purpose of GROUP BY in analytic SQL?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Aggregate rows that share selected dimension values
Explanation:
GROUP BY partitions detail rows into logical groups for aggregate functions.
It is commonly used to summarize facts by dimensions such as month or region.
Leave a Reply