What is the purpose of GROUP BY clause in SQL?
- To filter rows based on a condition
- To group rows based on the values in one or more columns
- To perform a join operation
- To sort the result set in ascending or descending order
The GROUP BY clause in SQL is used to group rows based on the values in one or more columns. It is often used in conjunction with aggregate functions to perform operations on each group separately, providing a way to analyze and summarize data.
Loading...
Related Quiz
- Scenario: You are developing an e-commerce application where products have varying attributes and categories. Which NoSQL database type would you choose for efficient product catalog management and why?
- The _______ consistency model in NoSQL databases prioritizes availability over consistency.
- Scenario: A financial institution manages a vast amount of transaction data in its database. Queries often involve retrieving transactions within specific date ranges or for particular account holders. How would you utilize indexing to enhance query performance in this scenario?
- An attribute is said to be _______ if it is dependent on the primary key, as well as on some other attribute(s) within the same table.
- Forward and Reverse Engineering tools often support _______ between different stages of the design process.