max()

Returns the highest row value in a numeric column.

max() follows this syntax.

SELECT max(column_name)
FROM dataset
WHERE condition;