|
Re: How to retrieve last record in a table... [message #255268 is a reply to message #255259] |
Tue, 31 July 2007 04:27   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
There is no "last record" in a relational database, unless you have something you can order the data by in the table.
When you have something to order the data by, then you can reverse the order and get the first row.
like
SELECT * FROM (
select * from your_table
order by your_order_column desc
) WHERE ROWNUM = 1
|
|
|
|
|
|
|
|