Google Ad Slot: content-top

MySQL MIN and MAX

MySQL `MIN()` and `MAX()` Functions

The MIN() functions in MySQL are used to find the smallest values in a column.

The MAX() functions in MySQL are used to find the largest values in a column.

SELECT MIN(column_name) FROM table_name;

SELECT MAX(column_name) FROM table_name;

Below is a selection from the "Students" table in the school_db database:

student_id	name	gender	city	age	score	course_id	email	phone_number
1	Alice	Female	Delhi	20	85	101	NULL	1234567890
2	Bob	Male	Mumbai	22	75	NULL	bob@email.com	NULL
3	Charlie	Male	Delhi	21	95	102	NULL	NULL
4	David	Male	Bangalore	23	65	101	david@email.com	NULL
5	Eve	Female	Mumbai	20	80	103	NULL	NULL
6	Frank	Male	Delhi	22	90	103	NULL	NULL
7	Alice	Female	Mumbai	19	60	102	NULL	NULL

The following SQL statement finds the lowest_score of the students:

Example

SELECT MIN(score) AS lowest_score FROM students;

Try it yourself

The following SQL statement finds the highest_score of the students:

Example

SELECT MAX(score) AS highest_score FROM students;

Try it yourself