max()

Returns the highest row value in a numeric column.

max() follows this syntax.

SELECT max(COLUMN_NAME)
FROM DATASET
WHERE CONDITION;