Home » SQL & PL/SQL » SQL & PL/SQL » How to find the nth maximum
How to find the nth maximum [message #3459] Sat, 28 September 2002 05:35 Go to next message
jayaratna
Messages: 2
Registered: September 2002
Junior Member
Hello friends,

Is there any way to find the nth maximum of a column of an table.
Like the second maximum ..third maximum n so on??
if so let me know.
Thanx in advance

Report message to a moderator

Re: How to find the nth maximum [message #3461 is a reply to message #3459] Sat, 28 September 2002 18:58 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You can use the analytical functions RANK or DENSE_RANK, or an inline view:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:364926266758

Report message to a moderator

Previous Topic: Number problem
Next Topic: How do I pass a table name as a parameter to a procedure so I can process the data from the table?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 02:20:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.