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:
Syntax
SELECT MIN(column_name) FROM table_name;
- Discover the minimum price listed.
Example
SELECT MIN(Mark) FROM tbl_Wikitechy;