The Max function returns the maximum value of an expression.
Max syntax
select max(expression) from table;
Max 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 max(price) from course; Result: 75 select max(price*2) from course; Result: 150