How To Use HAVING Clause In SQL

In this article, we will learn how to use the HAVING clause in SQL.

The WHERE clause could not be used with Aggregate Functions, so the HAVING clause was added to SQL.

Syntax

SELECT column_name(s)
FROM TABLE_NAME
GROUP BY column_name(s)
HAVING condition;

Example

The subsequent statement would list the number of viewers in each city. Only include cities with more than 5 viewers:

SELECT COUNT(ID), City
FROM Viewers
GROUP BY City
HAVING COUNT(ID) > 5;

Also, check How To Use GROUP BY Keyword In SQL

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.