OraFAQ Forum: SQL & PL/SQL » select Top 5 column values of a table

Home » SQL & PL/SQL » SQL & PL/SQL » select Top 5 column values of a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select Top 5 column values of a table [message #7506]

Wed, 18 June 2003 07:08

sabir
Messages: 18
Registered: April 2003

Junior Member

Hi Frnds,
My query is to find out top 5 values of a column.Something like "find out first five people who are recieving highest salary from scott.emp table"
We can use SCOTT.EMP for reference purpose

Thanks in advance

sabir

Report message to a moderator

Re: select Top 5 column values of a table [message #7507 is a reply to message #7506]

Wed, 18 June 2003 07:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Search the board, this question (or a similar) has been asked/answered more than once. If you can't find it, search asktom.oracle.com.

MHE

Report message to a moderator

Previous Topic:	Machine Name
Next Topic:	Subquery + where clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:12:25 CDT 2024