SQL - MIN

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

The 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