How do I do the following?
select top 1 Fname from MyTbl
In Oracle 11g?
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
1.4m articles
1.4m replys
5 comments
57.0k users