SQL MIN() Function

The MIN() function returns the lowest value of the selected column. The syntax:

SELECT MIN (column1) FROM table;

Let’s say that we want to retrive the lowest value from the Products table. We can use the following SQL MIN() statement:

SELECT MIN(amount) FROM products;

This SQL statement will produce the following result:

+-------------+
| min(amount) |
+-------------+
|      615.45 |
+-------------+