SQL MIN Function - SQL Server MIN() Function
The SQL MIN() Function
- The MIN() function retrieves the smallest value from a chosen column, providing a simple way to find the minimum value.
Demo Database
- This is a portion of the Wikitechy table that was referenced in the examples:
![table -Wikitechy](https://wikitechy.com/cdn/tutorials/sql/table-wikitechy.jpg)
Syntax
SELECT MIN(column_name) FROM table_name;
- Discover the minimum price listed.
Example
SELECT MIN(Mark) FROM tbl_Wikitechy;
Output
![sql-min-function](https://wikitechy.com/cdn/tutorials/sql/sql-min-function.jpg)