MIN Function
MIN returns the lowest value.
Syntax
sql
1SELECT MIN(column) FROM table;Example: Lowest Marks
sql
1SELECT MIN(marks) AS lowest FROM students;With WHERE
sql
1SELECT MIN(age) FROM students
2WHERE grade = 'A';
MIN returns the lowest value.
1SELECT MIN(column) FROM table;1SELECT MIN(marks) AS lowest FROM students;1SELECT MIN(age) FROM students
2WHERE grade = 'A';