Eine Einführung in


How can I select the oldest person in the table PERSON by birthday?


I have a table PERSON(personID, name, sex, birthday, placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.

Use a nested query to find the earliest birthday.

Specific to MySQL

We can order by birthday and select the first one only.

If there are two or more oldest people then only one of them will be returned.