2006-06-15 11:00:55 · 3 answers · asked by Jigar 1 in Computers & Internet ➔ Programming & Design
http://www.knowdotnet.com/articles/getage.html
A complete guide for your problem. Hope it helps :)
2006-06-15 11:03:09 · answer #1 · answered by snoopyagent007 2 · 1⤊ 0⤋
What does the database look like?
You have to have a table and a column that contains age information and a table and column that contains corresponding names. With that, you can write an SQL select statement to filter, sort, and present names & age.
2006-06-15 18:04:52 · answer #2 · answered by OMG, I ♥ PONIES!!1 7 · 0⤊ 0⤋
I will explain u here for Oracle 9i.
1) Let take the table name as Employee. If the table already have the age field then use the below query.
select name,age from employee
which display name and age of employee.
2) If the table having the date of birth only. we have to use the following query.
select (sysdate-age)/360 from employee
2006-06-16 04:38:43 · answer #3 · answered by Suresh k 1 · 0⤊ 0⤋