What is the purpose of the GROUP BY clause in an SQL query?
- It is used to aggregate data based on specified columns, grouping the results.
- It is used to filter records based on a specified condition.
- It is used to join multiple tables in a query.
- It is used to sort records in ascending or descending order.
The GROUP BY clause is used to aggregate data based on specified columns. It groups the results and allows for the application of aggregate functions like COUNT, SUM, AVG, etc., on each group separately.
Loading...
Related Quiz
- For a sales dashboard, what type of visualization is typically used to represent sales trends over time?
- _______ charts are effective for displaying part-to-whole relationships and comparing different categories over time.
- In decision making, understanding the _______ of a decision helps in evaluating its long-term impacts.
- What is the main benefit of using a cloud-based data warehouse over a traditional data warehouse?
- In data preprocessing, what does 'normalization' refer to?