Getting last N records Using rownum

[Guru3i]

Hi Tim,

Advanced Christmas Greetings.

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.

Thanks in advance

[Tim...]

Hi.

You need to use a Top-N query:

http://www.oracle-base.com/articles/mis ... ueries.php

Cheers

Tim...

[Guru3i]

Hi Tim,

Say i have 100 rows in a table and i want to delete rows from rownum 50 to 75, how could i do this. Please help.

Thanks

[Guru3i]

Hi Tim,

I was able to write for myself, thanks for your time.

Thanks

[Tim...]