Max and min functions
Updated at:
max returns the maximum value in a specified column. min returns the minimum value in a specified column.
Syntax
max(column)
min(column)Examples
Basic aggregation
Return the maximum or minimum value in a column:
SELECT max(c1) FROM test;
SELECT min(c1) FROM test;Is this page helpful?