PL/SQL Max

The Max function returns the maximum value of an expression.

Max syntax

select max(expression) from table;

Max example

COURSE_IDNAMEDESCRIPTIONDURATIONPRICE
1SQL 1SQL course for beginners1 week10
2SQL 2SQL course for advanced2 week50
3HTML5Learn HTML 51 week10
4PHPPHP course4 week75
5CSSLearn CSS2 week20
select max(price) from course;

Result: 75


select max(price*2) from course;

Result: 150