Home » RDBMS Server » Server Administration » Very Interesting Question
Very Interesting Question [message #373935] Thu, 17 May 2001 10:12 Go to next message
sriram
Messages: 58
Registered: September 2000
Member
Hi everybody,
i have a question to ask:
"How do I find out the oldest record in a Oracle table"
By oldest , i mean , the first inserted record.
Please feel free to contact me at sriram22@123india.com
Regards
Sriram

Report message to a moderator

Re: Very Interesting Question [message #373977 is a reply to message #373935] Fri, 18 May 2001 05:25 Go to previous message
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
Member
Hai SriRam,
I think we can get the required output with the following query.

select * from EMP where rowid = (select min(rowid) from EMP);

Check it out and revert.

Cheers,
Giridhar Kodakalla

Report message to a moderator

Previous Topic: Foxpro Like IIf() function in Oracle
Next Topic: Re: How to find out forein keys
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 04:08:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.