Home » SQL & PL/SQL » SQL & PL/SQL » Rank function
Rank function [message #298084] Tue, 05 February 2008 00:02 Go to next message
nivas007
Messages: 7
Registered: July 2007
Location: Hydera bad
Junior Member

HI All,

how to get rank in a table of rows (with duplicate entries) but rank should be unique..

Thanks in advance....

Regards,
Nivas..
Re: Rank function [message #298085 is a reply to message #298084] Tue, 05 February 2008 00:04 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
If you have a basket with a number of different colored balls, please rank the balls programatically.

[Updated on: Tue, 05 February 2008 00:04] by Moderator

Report message to a moderator

Re: Rank function [message #298096 is a reply to message #298084] Tue, 05 February 2008 00:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DENSE_RANK

Regards
Michel
Re: Rank function [message #299081 is a reply to message #298096] Fri, 08 February 2008 23:27 Go to previous message
nivas007
Messages: 7
Registered: July 2007
Location: Hydera bad
Junior Member

Hi Michel,

Thanks for the reply.
the information which you are given is very useful to fulfill my requirement.

Thanks,
Nivas..
Previous Topic: Sql query using Sum function and Having clause
Next Topic: Using Variables with SQL
Goto Forum:
  


Current Time: Sat Dec 10 04:58:59 CST 2016

Total time taken to generate the page: 0.04388 seconds