Oracle SQL

Aggregating Data Using Group Functions Using the HAVING clause

Having Cause Insert Into Group By
Written by shohal
What is having clause in Oracle SQL?

A HAVING clause in SQL specifies that an SQL SELECT statement must only return rows where aggregate values meet the specified conditions. HAVING and WHERE are often confused by beginners, but they serve different purposes.

Below to Related Topic Link:

Difference between where and having cause?

Where cause use before Group by Cause.

Having cause use after Group by Cause.

  • Where cause doesn’t use the aggregate function.
  • Having cause uses an aggregate function.

Link ( group by function in Oracle SQL ) :

About the author


Leave a Comment