PL/SQL Min

 

The Min function returns the minimum value of an expression.

Min syntax

select min(expression) from table;

Min example

COURSE_ID NAME DESCRIPTION DURATION PRICE
1 SQL 1 SQL course for beginners 1 week 10
2 SQL 2 SQL course for advanced 2 week 50
3 HTML5 Learn HTML 5 1 week 10
4 PHP PHP course 4 week 75
5 CSS Learn CSS 2 week 20 
select min(price) from course;

Result: 10


select min(price*2) from course;

Result: 20