how to select last row?

[trogen]

What sql statement will allow me to select the row that was added LAST to a table?
thanks.

[marist89]

Hopefully you have a timestamp column on your table. Otherwise, you can't do it consistently.

[akkerend]

Or a column based on a sequence.

[Kadubur]

Hi

Use Rowid..

Ex:
select * from emp where rowid in (select max(rowid) from emp);

I hope it works..

[akkerend]

This does't work. You don't know where new rows are inserted. After rows are deleted, new rows can be inserted in the datablocks of the deleted rows.

[trogen]

ok, say I have a timestamp column in the table.
What sql statment will allow me to select the last row with the latest time stamp.
An SQL example would help,
thanks.

[marist89]

I agree with akkerend. The rowid will yield the last row in the table, not necessarily the last row inserted into the database.

If you have a timestamp column:

select * from emp
where timestamp_col = (select max(timestamp_col) from emp)