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