display only desired number (n) of rows in sql result

 

select * from table_name where rownum < n;

 

 

#