SELECT command with MAX () function

Max () function returns maximum value of column.

Syntax:

SELECT MAX ([SPECIFIED_COLUMN_NAME]) FROM <TABLE_NAME>

Example:

--- CALCULATE MAX VALUE OF COLUMN USING MAX FUNCTION

SELECT MAX(SALARY) FROM STUDENT_MARKS