SQL MIN() Function

The MIN() Function

The MIN() function returns the smallest value of the selected column.

SELECT MIN(column_name) FROM table_name

We have the following "Orders" table:

Now we want to find the smallest value of the "OrderPrice" column.

We use the following SQL statement:

SELECT MIN(OrderPrice) AS SmallestOrderPrice FROM Orders

The result-set will look like this:

SmallestOrderPrice

100