Updated on 2023-10-31 GMT+08:00

HAVING

Filters data based on grouping and Aggregate Functions.

SELECT age, MAX(balance) GROUP BY age HAVING MIN(balance) > 10000
Table 1 The HAVING function

age

MAX(balance)

28

32838

32

39225