MAX

SQL MAX Function

The MAX function returns the maximum value in the expression.

SQL MAX syntax

SELECT MAX(column_name)
FROM table_name;

Training_Course

IDNAMEDURATIONPRICE
1SQL5200
2T-SQL7700
3MySQL5600
4PL/SQL7800
5PostgreSQL6500

Example

select MAX(PRICE) from Training_Course;

Results

800