Re: query on last inserted record.....please help

<madhusudan.hv_at_gmail.com> a écrit dans le message de news:1103707234.740544.285300_at_z14g2000cwz.googlegroups.com...
| my table structure is like this
| tablename: address
|
| 1.patientuid - foreign key referring to patient table
| 2.addressuid
| 3. street
| 4. city
| 5. addresstype - foreign key referring to address table
|
| this database is currently running on many client sites.
| the application allows us to insert multiple addresses and it used
| to show all of them on the gui.
| now according to the new requirement we have show only the last
| inserted
| address by making changes only in query code and not touching the
| database.
| how to fetch the last inserted record for each patient?
| please help me........
|

If you don't already have a timestamp somewhere, you can't. But if addressuid is an ordered id then you can use it as timestamp.

Regards
Michel Cadot Received on Wed Dec 22 2004 - 03:37:37 CST