PostgreSQL Having Clause

In PostgreSQL, HAVING clause is used in combination with GROUP BY clause to pick out particular rows where the function's result meets some condition.

Syntax:

SELECT column1, column2
FROM table1, table2
WHERE [ conditions ]
GROUP BY column1, column2
HAVING [ conditions ]
ORDER BY column1, column2

See this example:

Let's take a table "EMPLOYEES" having the following data.

See this example, which would display record for which name count is less than 2.

Execute the following query:

SELECT "NAME" 
FROM "EMPLOYEES"
GROUP BY "NAME" HAVING COUNT ("NAME") < 2;

Output:

Example2:

Let's insert some duplicate records in the "EMPLOYEES" table. Add the following data:

INSERT INTO "EMPLOYEES" VALUES (5, 'Ajeet', 24, 'Delhi', 35000);
INSERT INTO "EMPLOYEES" VALUES (6, 'Manisha', 19, 'Noida', 25000);
 

Output:

Execute the following query to retrieve the name from table "EMPLOYEES" where name count is greater than 1.

SELECT "NAME"
FROM "EMPLOYEES"
GROUP BY "NAME" HAVING COUNT ("NAME") > 1;

Output:

Next TopicPostgreSQL Conditions

← prev next →

PostgreSQL Tutorial

PostgreSQL Database

PostgreSQL Table

PostgreSQL Schema

PostgreSQL Queries

PostgreSQL Clause

PostgreSQL Conditions

PostgreSQL Views

PostgreSQL Join

PostgreSQL Advance

Interview

Quiz

PostgreSQL Having Clause

Example2: