The max function returns the maximum value in a specified column. The min function returns the minimum value in a specified column.

Examples

SELECT max(c1) FROM test;
SELECT min(c1) FROM test;