{"id":2450,"date":"2013-05-16T23:21:54","date_gmt":"2013-05-17T07:21:54","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=2450"},"modified":"2023-11-09T07:33:05","modified_gmt":"2023-11-09T14:33:05","slug":"mysql-min","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-aggregate-functions\/mysql-min\/","title":{"rendered":"MySQL MIN() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL MIN()<\/code> function to find the minimum value in a set of values.<\/p>\n\n\n\n

Introduction to MySQL MIN() function<\/h2>\n\n\n\n

The MIN()<\/code> function returns the minimum value in a set of values. The MIN()<\/code> function is very useful in some scenarios such as finding the smallest number, selecting the least expensive product, or getting the lowest credit limit.<\/p>\n\n\n\n

Here’s the basic syntax of the MIN()<\/code> function:<\/p>\n\n\n

MIN(DISTINCT expression);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the MIN()<\/code> function accepts an expression that can be a column or a valid expression that involves columns.<\/p>\n\n\n\n
The DISTINCT<\/code> does not have any effect on the MIN()<\/code> function like other aggregate functions<\/a> such as SUM()<\/a><\/code>, AVG()<\/a><\/code>and COUNT()<\/a><\/code>.<\/p>\n\n\n\n
MySQL MIN function examples<\/h2>\n\n\n\n
We’ll use the products<\/code> table in the sample database<\/a> for the demonstration.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
1) Using MySQL MIN() function to find the minimum value in a column<\/h3>\n\n\n\n
This query uses the MIN()<\/code> function to get the lowest price of all products from the products<\/code> table:<\/p>\n\n\n
SELECT<\/span> \n    MIN<\/span>(buyPrice)\nFROM<\/span>\n    products;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
\"MySQL<\/figure>\n\n\n\n
In this example, the query checks all values in the column buyPrice<\/code> of the products<\/code> table and returns the lowest value.<\/p>\n\n\n\n
2) Using MySQL MIN() with a WHERE clause example<\/h3>\n\n\n\n
This example uses the MIN()<\/a><\/code> function to find the lowest buy price of all motorcycles:<\/p>\n\n\n
SELECT<\/span> \n    MIN<\/span>(buyPrice)\nFROM<\/span>\n    products\nWHERE<\/span>\n    productline = 'Motorcycles'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this example:<\/p>\n\n\n\n
Try It Out<\/a><\/p>\n\n\n\n