Thursday, April 26, 2012

How to select 'n' number of rows in oracle?

Use this query,

select * from table_name where rownum < 'n';

table_name is your table name.
'n' is number of rows you want to retrive.

No comments:

Post a Comment