Updated on 2024-07-18 GMT+08:00

Analysis Statements - 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