Monday, 19 May 2014

How to get First N records from Oracle Database Table ?

How to get  First  10 records from Oracle Database Table ?

 Very simple query :
    SELECT * FROM (SELECT * FROM TABLE_NAME FROM WHERE ROWNUM <=10);
 
How to get Top N records from Oracle Database Table ?
  SELECT * FROM
     (select * from country_name ORDER BY  ctr_name desc )
    SUPPLIER2
   WHERE ROWNUM <=3  ORDER BY rownum;

No comments:

Post a Comment