HAVING clause

• Same as WHERE clause except it allows aggregate functions

• Often used with GROUP BY

• Must come after GROUP BY when both are used in a query.

• Unlike WHERE, all the fields in the HAVING list must also be in the SELECT list.

Previous slide

Next slide

Back to first slide

View graphic version