|
|
![]() |
|
![]() |
| SQL Max |
|
|
|
|
|
| Home › SQL Max |
|
|
|
The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column. |
|
The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.
The SQL MAX function syntax is very simple and it looks like this:
SELECT MAX(Column1)
FROM Table1
|
If we use the Customers table from our previous chapters, we can select the highest date of birth with the following SQL MAX expression:
SELECT MAX(DOB) AS MaxDOB
FROM Customers
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Home › SQL Max |
Top |
|
|
|
|
