How to do top 1 in Oracle ?

Question

hi

how to do this: select top 1 Fname from MyTbl

in oracle 11g ?

thank's in advance

Answer 1

Have a look at How does one select the TOP N rows from a table

Answer 2

If you want just a first selected row you can:

select fname from MyTbl where rownum = 1

you can also use analytic functions to order and take the top x

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

Answer 3

select * from (
    select FName from MyTbl
)
where rownumn <= 1;

Answer 4

SELECT *
  FROM (SELECT * FROM MyTbl ORDER BY Fname )
 WHERE ROWNUM = 1;

Answer 5

Use:

SELECT x.*
  FROM (SELECT fname 
          FROM MyTbl) x
 WHERE ROWNUM = 1

If using Oracle9i+, you could look at using analytic functions like ROW_NUMBER() but they won't perform as well as ROWNUM.