How to retrieve top 10 records from ORACE Table

How to retrieve top 10 records from ORACE Table

SELECT *
FROM (select * from suppliers ORDER BY supplier_name) suppliers2
WHERE rownum <= 10
ORDER BY rownum;

select * from table_name where rownum <11;