Function to get TOP 100 records

[nishant]

select * from table_name where rownum <=100;
take care,
Nishant.