OraFAQ Forum: Forms » How to get 4th highest salary

Home » Developer & Programmer » Forms » How to get 4th highest salary

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

How to get 4th highest salary [message #134851]

Sun, 28 August 2005 03:58

mrpranab
Messages: 32
Registered: March 2005

Member

hi,
how can i get the 4th highest salary or
5th highest salary?what query i can use for it?
say i have emp table where sal is the
concerned field.in emp 100 employees is there
and i want the one whose salary is 4th highest salary.
regards
Pranab

Report message to a moderator

Re: How to get 4th highest salary [message #134860 is a reply to message #134851]

Sun, 28 August 2005 07:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

http://www.orafaq.com/forum/m/119369/43055/

MHE

Report message to a moderator

Re: How to get 4th highest salary [message #134972 is a reply to message #134851]

Mon, 29 August 2005 04:57

reachme_r
Messages: 8
Registered: July 2005
Location: india

Junior Member

Hi,
try this sql query :

select sal from emp a
where 4 = (select count(distinct sal) from emp b
Where a.sal <= b.sal)

Report message to a moderator

Re: How to get 4th highest salary [message #150516 is a reply to message #134851]

Thu, 08 December 2005 05:02

m_Usuf
Messages: 21
Registered: November 2005
Location: Karachi Pakistan

Junior Member

Hi

Good day
Find Attach File May be it Will help you

Thanks

Yousuf

Attachment: QUERY.doc
(Size: 19.50KB, Downloaded 1068 times)

[Updated on: Thu, 08 December 2005 05:03]

Report message to a moderator

Re: How to get 4th highest salary [message #150522 is a reply to message #150516]

Thu, 08 December 2005 05:15

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Locked this old thread...

MHE

Report message to a moderator

Previous Topic:	How To Go to next item from multiline text item
Next Topic:	Elements in Lists

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:24:15 CDT 2024