OraFAQ Forum: SQL & PL/SQL » how to select nth maximum in a table

Home » SQL & PL/SQL » SQL & PL/SQL » how to select nth maximum in a table

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

how to select nth maximum in a table [message #232593]

Sat, 21 April 2007 14:51

narsi1226
Messages: 4
Registered: April 2007

Junior Member

hai to all,
i want to select Nth maximum salary of an employees table (i mean if two persons having Nth maximum salary , i want to display the name of two persons

Report message to a moderator

Re: how to select nth maximum in a table [message #232596 is a reply to message #232593]

Sat, 21 April 2007 15:08

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at dense_rank function.

Regards
Michel

Report message to a moderator

Re: how to select nth maximum in a table [message #232608 is a reply to message #232596]

Sun, 22 April 2007 03:52

ammishra
Messages: 179
Registered: January 2007
Location: india

Senior Member

try this

select d.last_name,d.salary from (select salary,last_name,dense_rank() over(order by salary desc) rd from employee ) d where d.rd=4

--Yash

Report message to a moderator

Re: how to select nth maximum in a table [message #232613 is a reply to message #232608]

Sun, 22 April 2007 07:20

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And what do you add to my previous answer?
Just to show us that you can read the documentation?
Well, you're a good boy.

Regards
Michel

Report message to a moderator

Re: how to select nth maximum in a table [message #232618 is a reply to message #232608]

Sun, 22 April 2007 11:04

narsi1226
Messages: 4
Registered: April 2007

Junior Member

thanks for sending reply to my question

Report message to a moderator

Re: how to select nth maximum in a table [message #232619 is a reply to message #232618]

Sun, 22 April 2007 11:08

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You should not thank someone that gives you a solution instead of teaching how to find it by yourself.
It turns you to a slave.

Regards
Michel

Report message to a moderator

Previous Topic:	Hi Guys Please help me in removing this bug...
Next Topic:	Check these!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 12:37:46 CST 2024