Aggregations Part 5 — MAX()

See below how to calculate the Maximum population among the 4 California cities from the dataset on the right:

SELECT MAX(2022 estimate)

FROM database_table

WHERE ST = ‘CA’

  • Now, the SQL statement returns the Max value of 3.8 million (from the Los Angeles row).