Having Clause

How To Use Having Clause In SQL

Introduction:
In this article, you will learn what “Having” clause is and how to use “Having” clause in SQL.

The SQL Having clause is used to filter the records, which belongs to Group By function. Having clause depends on the Group By clause. When we use Where Group By and Having clause in a statement then Where clause change first (exchanged rows) and execution of Where clause is based on the Group By clause.

We cannot use Group By function in Where clause but we can use Group By function in Having clause. Having clause is used in SQL because Where clause does not exist with the aggregate function.

There is some situation for Having Clause query:

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Syntax:

The basic syntax of Having Clause is as follows:

SELECT column1, column2

FROM table1, table2

WHERE [ conditions ]

GROUP BY column1, column2

HAVING [ conditions ]

ORDER BY column1, column2

Example:

Here, we have an Employee table for showing the Having Clause.

Step1: First we write the query for Having Clause.

Now select and execute this query.

Step 2: Then the output of Having Clause is:

Summary:
Thus, we learned that Having Clause is used to filter data using Group By function and also learn it's used in SQL.