PostgreSQL Having Clause

  • Having Clause is used to Filter The Records
Syntax:-
SELECT Column1, aggregate_function(Column2)
FROM TABLE
GROUP BY Column1
HAVING CONDITION;
Without Having Clause.

Let’s Filter the Records using Having Clause.

using Having Clause
  • Without Group by , we cant use Having Clause
Error

Happy Queries, Thanks…

Post Author: adama