SQL HAVING

Published May 7, 2021Updated Sep 3, 2021

Contribute to Docs

A conditional statement similar to WHERE but used with aggregate functions (COUNT(), MIN(), MAX(), SUM(), AVG()).

Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Includes 9 Courses
With Certificate
Beginner Friendly.
17 hours
Skill path
Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses
With Certificate
Beginner Friendly.
13 hours

Code Example

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_country
FROM students
GROUP BY birth_country
HAVING COUNT(student_name) < 25;

Copy to clipboardCopy to clipboard

All contributors

christian.dinh
Anonymous contributor

Contribute to Docs

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

Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Includes 9 Courses
With Certificate
Beginner Friendly.
17 hours
Skill path
Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses
With Certificate
Beginner Friendly.
13 hours