Getting partial resultset in Oracle

[Anon]

Hi
I have table with huge number of records. Can i get few records(like 1 to 100, 100 to 200) at a time using only SQL(if possible). So i can show user partial data.

MySQL supports this type of getting resultset with keyword 'limit'.

regards
sriram

[Anon]

You can use the rownum property
Select * from your_table
Where rownum <= 100

This query will give you the first 100 records