Published May 7, 2021Updated Sep 3, 2021
Contribute to Docs
A conditional statement similar to
WHERE but used with aggregate functions (
To return a result set of the number (count) of students from each country if the total number is less than 25:
SELECT COUNT(student_name),birth_countryFROM studentsGROUP BY birth_countryHAVING COUNT(student_name) < 25;
- Anonymous contributorAnonymous contributor
- Anonymous contributor
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.
Learn SQL on Codecademy
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses