Reading the last record in the db

[Anon]

How can I use the select statement to return the last row in the data base?
The row will have the largest Id number, but I can't figure out how to phrase, could I use the max(id) someway.

Thanks

[sankvs]

Would something like the following statement help ?

select * from table where id = (select max(id) from table);

Alternately you can rely on the rownum to limit the number of rows. This is similar to:

select * from table where rownum < 2 order by id desc;

Regards
Vasu

[Anon]

If you're using a db that supports "LIMIT" you could just do "select * from table order by id desc limit 1"

[Anon]

Thanks Guys.