Vignesh Jayavel

Select top n records from a table (Oracle)

Select top n records from a table (Oracle)

select * from table_name where rownum <= :n ; /* n is the number of records you need to fetch */