{"id":165,"date":"2016-03-24T13:20:56","date_gmt":"2016-03-24T13:20:56","guid":{"rendered":"https:\/\/sqltutorial.org\/?page_id=165"},"modified":"2025-01-18T21:42:23","modified_gmt":"2025-01-19T04:42:23","slug":"sql-min","status":"publish","type":"page","link":"https:\/\/www.sqltutorial.org\/sql-aggregate-functions\/sql-min\/","title":{"rendered":"SQL MIN Function"},"content":{"rendered":"\n

Summary<\/strong>: this tutorial helps you master the SQL MIN<\/code> function through practical examples. After the tutorial, you will know how to apply the MIN <\/code>function effectively to find the minimum value in a set of values.<\/p>\n\n\n\n

Introduction to SQL MIN function #<\/a><\/h2>\n\n\n\n

The SQL MIN<\/code> function returns the minimum value in a set of values. <\/p>\n\n\n\n

Here’s the syntax of the MIN<\/code> function.<\/p>\n\n\n

MIN(expression)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SQL MIN function examples #<\/a><\/h2>\n\n\n\n
We’ll use the employees<\/code> table to demonstrate the functionality of the MIN<\/code> function.<\/p>\n\n\n\n
\"employees_table\"<\/figure>\n\n\n\n
To find the lowest (minimum) salary of employees, you apply the MIN<\/code> function to the salary<\/code> column of the employees<\/code> table.<\/p>\n\n\n
SELECT<\/span>\n  MIN<\/span>(salary) min_salary\nFROM<\/span>\n  employees;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
 min_salary<\/span>\n------------<\/span>\n    2500.00<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span>\n  first_name,\n  last_name,\n  salary\nFROM<\/span>\n  employees\nWHERE<\/span>\n  salary = (\n    SELECT<\/span>\n      MIN<\/span>(salary)\n    FROM<\/span>\n      employees\n  );<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
 first_name | last_name  | salary\n------------+------------+---------\n Karen      | Colmenares | 2500.00<\/code><\/span><\/pre>\n\n\n
How the query works:<\/p>\n\n\n\n
Try it<\/a><\/p>\n\n\n\n
To get the information of the employee who has the lowest salary, you use the following subquery<\/a>:<\/p>\n\n\n
Try it<\/a><\/p>\n\n\n\n
Like the MAX function<\/a>, the MIN<\/code> function also ignores NULL<\/code> values and does not have any effect when using the DISTINCT<\/a> option.<\/p>\n\n\n\n