GROUP BY

christian.dinh2481 total contributions
Published May 7, 2021Updated Jun 25, 2022
Contribute to Docs
The GROUP BY
command groups a result-set of rows, usually based on an aggregate function.
Syntax
SELECT column(s)
FROM table
GROUP BY column(s)
The aggregate function is usually applied on the same line as the SELECT command.
Example
The following example returns a result set of the number (count) of students from each country:
SELECT COUNT(student_name),birth_countryFROM studentsGROUP BY birth_country;
All contributors
- christian.dinh2481 total contributions
- Anonymous contributorAnonymous contributor3077 total contributions
- BrandonDusch580 total contributions
- christian.dinh
- Anonymous contributor
- BrandonDusch
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.