I want to have a query which lists only the last N records from a table. I need to do this only using rownum function. Can you please help me in doing this. If my table has 100 records, i should be able to see only the record from 91 to 100. Hope i have made it clear.