Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to find last record in a table?
Hey, gang.
I've been relying on a simple little statement that I THOUGHT would
show me the last record in a table. I found out today that it's
unreliable (returned records that were inserted on December 12 when
there were records from today).
Here's my statement...
select * from <table> where rowid = (select max(rowid) from <table>);
What do you guys do to find the last record in a table?
Thanks. Received on Wed Jan 14 2004 - 13:03:37 CST
![]() |
![]() |