The MIN() Function

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

SQL MIN() Syntax

SELECT MIN(column_name) FROM table_name

---

SQL MIN() Example

We have the following “Orders” table:

O_Id OrderDate OrderPrice Customer

1
2008/11/12
1000
Hansen

2
2008/10/23
1600
Nilsen

3
2008/09/02
700
Hansen

4
2008/09/03
300
Hansen

5
2008/08/30
2000
Jensen

6
2008/10/04
100
Nilsen

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

Have you found this script useful? Please support author by PayPal donation.

• SQL GROUP BY Statement
• SQL LAST() Function
• SQL FIRST() Function
• SQL AVG() Function
• SQL HAVING Clause
• SQL COUNT() Function
• SQL RIGHT JOIN Keyword
• SQL Alias
• SQL LEFT JOIN Keyword
• SQL LEN() Function