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