The Oracle HAVING clause is used in conjunction with the Oracle GROUP
BY clause to limit the returned rows after the grouping.
SQL statements can utilize both a WHERE clause and an Oracle HAVING
clause. The WHERE clause will filter rows as they are selected from the
table, and before grouping, the Oracle HAVING clause will filter rows
after the grouping.
An example of the Oracle HAVING clause can be seen below:
The Oracle HAVING clause can be used with other
functions such as COUNT, MIN, and MAX as well.
The Oracle HAVING clause is a great asset when it
comes to grouping related rows.
For more information about the Oracle HAVING clause see the following
links:
