| SQLite |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to SQLite |
| none |
| DB2 |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to DB2 |
| none |
| MS Access |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to MS Access |
| none |
| PostgreSQL |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to PostgreSQL |
| none |
| Oracle |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to Oracle |
| none |
| MS SQL Server |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to MS SQL Server |
| none |
| MySQL |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
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. |
| Sybase |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to Sybase |
| none |
| Mimer SQL |
|
I have a table PERSON(personID,
name,
sex,
birthday,
placeOfBirth)
Now I would like to SELECT the oldest person in the table by birthday.
Answer:
Use a nested query to find the earliest birthday. |
|
|
| Specific to Mimer SQL |
| none |