SQL Tutorial - Learn SQL

SQL MIN - SQL Tutorial

The SQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.

The SQL MIN function syntax is very simple and it looks like this:


SELECT MIN(Column1)
FROM Table1

If we use the Customers table from our previous chapters, we can select the lowest date of birth with the following SQL MIN expression:


SELECT MIN(DOB) AS MinDOB
FROM Customers