Oracle top 1 record

To select the top 1 records from an oracle database, you filter with the where statement on rownum = 1:

select * from my_table where rownum = 1

If you want to select top 10 records from the table you use the following statement:

select * from my_table where rownum <= 10