Ingres 11.0 | HAVING Clause

OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Statements > SELECT (interactive) > HAVING Clause

Was this helpful?

HAVING Clause

The HAVING clause filters the results of the GROUP BY clause, in the same way the WHERE clause filters the results of the SELECT...FROM clauses. The HAVING clause uses the same restriction operators as the WHERE clause.

For example, to return the number of orders placed today for each part:

select odate, partno, count(*) from orders
group by odate, partno
having odate = date('today');

Last modified date: 01/30/2023