[Oracle][Resolved] SQL for orcale to limit result amount

10g version : 

SELECT * FROM 

  (SELECT * FROM ARTICLE) 

WHERE ROWNUM <=5;

Syntax supported by 12g version:

SELECT * FROM article 

ORDER BY article_id

OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY;

Reference:

https://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering/26051830#26051830