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 the SQL Tuning Advisor?
- What is RVWR?
- What are the components of the Relational Model?
- What is the getColumnCount() method?
- Database Transaction and Security