How do I do top 1 in Oracle?

Question

How do I do the following?

select top 1 Fname from MyTbl

In Oracle 11g?

Answer 1

You can try the below query if you want to use the first selected row.

Query:

select fname from MyTbl where rownum = 1

To order and take the top x, You can use analytic functions like this:

select max(fname) over (rank() order by some_factor) from MyTbl