Q. What does the GROUP BY clause do in a SQL query?
Solution:
GROUP BY is used with aggregate functions (e.g., COUNT, SUM) to group rows based on common values in one or more columns.
Related Questions
Q. Which query would count the number of distinct cities in the ‘Customers’ table?
View SolutionQ. What is the purpose of the HAVING clause?
View SolutionQ. How can you remove a table from the database?
View Solution
Get Question Bank
Strengthen Your Practice with our comprehensive question bank.
