MIN() and MAX() FUNCTIONS IN MySQL?

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

Posted on by