What is the GROUP BY clause?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the GROUP BY clause?
Rating:
The GROUP BY clause is used in a SQL SELECT statement to collect data across multiple records and group the results by one or more columns.
The syntax for using the GROUP BY clause is as follows:
FROM <table name>
WHERE <conditions>
GROUP BY <columns>
Rating:
Was this information helpful?
Other articles
- What is an integrity constraint?
- What is transaction logging?
- What is a complete recovery?
- What is a view?
- What is the Memory Advisor?