select * from table where rownum<=10;
select * from table fetch first 10 rows only;
select * from table limit 10;