How to retrieve the last 2 records from table?
===

I have a table with n number of records

How can i retrieve the nth record and (n-1)th record from my table in SQL without using derived table ?

I have tried using `ROWID` as

    select * from table where rowid in (select max(rowid) from table);

It is giving the nth record but i want the (n-1)th record also .
And is there any other method other than using `max,derived table and pseudo columns `

Thanks