How to find who is eldest from date of birth

[rahulae]

how can we find who is eldest from his date of birth

[amitpatel66]

What you are exactly trying to do here?

[samir pradhan]

hi
subtract the "date of birth" from "sysdate" to get the age and then find out who is eldest.

[debasisdas]

you can simply sort the database table as per date_of _birth field.