Home » RDBMS Server » Server Administration » Re: Select Row
Re: Select Row [message #370299] Tue, 17 August 1999 05:17 Go to next message
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
Sadly, AFAIK, there's no built-in way of retrieving the last-entered row of a table. It's a principle of relational databases that the order in which data is entered should not be significant.

If it is significant to your application, you'll have to write a database trigger to either timestamp or sequence-number each row as it is inserted.

-- Chris

Re: Select Row [message #370300 is a reply to message #370299] Wed, 18 August 1999 03:13 Go to previous message
FJD
Messages: 1
Registered: August 1999
Junior Member
Possibly the followunf query might help you
select * from x where rowid = (select
max(rowid) from x)
Previous Topic: Re: Join with Subsquery (in operator)
Next Topic: Rollback Segments.
Goto Forum:
  


Current Time: Sat Oct 24 04:48:27 CDT 2020