SQL MAX FUNCTION

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 Company 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 Company

MORE BASIC SQL COMMANDS