MySQL MIN Function

Introduction to MySQL MIN Function

This MySQL tutorial explains how to use the MIN function with syntax and examples. The MySQL MIN function returns the minimum value in a set of values.

MIN() Syntax

SELECT MIN(column_name)
FROM table_name
WHERE condition;

To understand MIN function, consider an “books” table, which is having the following records:

SELECT * FROM books;

The following MySQL statement finds the price of the most cheapest book:

SELECT MIN(Price) AS SmallestPrice
FROM books;

The following MySQL statement finds the price of the most cheapest book in each author, sorted low to high:

SELECT MIN(Price) AS SmallestPrice, Author
FROM books
GROUP BY Author
ORDER BY SmallestPrice ASC;