Table : Students
| Sl No |
Name |
Marks |
| 1 |
Bhanu |
25 |
| 2 |
Nikitha |
45 |
| 3 |
Sindhu |
30 |
| 4 |
Divya |
20 |
| 5 |
Shilpa |
49 |
SQL MIN() Functions:
The MIN() function returns the smallest value of the selected column.
SELECT MIN(Marks) FROM Students;
Output: 20
SQL MAX() Functions:
The MAX() function returns the largest value of the selected column.
SELECT MAX(Marks) FROM Students;
Output: 49