What is the purpose of the SQL GROUP BY clause?
- Filtering records
- Grouping similar data
- Joining tables
- Sorting records
The SQL GROUP BY clause is used to group rows that have the same values into summary rows, such as "find the number of customers in each city" or "calculate the total sales for each product category." It is typically used with aggregate functions (like COUNT, SUM, AVG, etc.) to perform calculations on each group of data. This clause helps in analyzing data by organizing it into manageable chunks based on specified criteria.
Loading...
Related Quiz
- Scenario: During a test script execution, a script that was previously passing now fails unexpectedly. What approach should you follow to investigate and resolve this issue?
- What is the purpose of a test dashboard in test reporting and metrics?
- What is the purpose of data profiling in data migration testing?
- Which type of testing ensures that users can access only the resources and features they are authorized to use?
- In ETL testing, the process of transforming data from source to target is known as ____________.