PL/SQL Min

 

The Min function returns the minimum value of an expression.

Min syntax

select min(expression) from table;

Min 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 min(price) from course;

Result: 10


select min(price*2) from course;

Result: 20