Re: Rank Based on Three Columns

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 7 Feb 2006 19:16:59 +0100
Message-ID: <43e8e41b$0$27114$626a54ce@news.free.fr>

"Mr.C" <cornelius.alfred_at_gmail.com> a écrit dans le message de news: 1139334666.858128.191480_at_g14g2000cwa.googlegroups.com...
| Hi All,
|
| I am using SQL Server 2000, and I am trying to rank based on three
| columns (A, B, C) all contain numeric values. First off I am trying to
| rank base on COLUMN A, if there are any ties (same numeric value) then
| the values of COLUMN B is used as the tie breaker. Likewise if there is
| still a tie in COLUMN B, the COLUMN C is used to break the tie. In the
| event the value of a record in COLUMN A, B, C are same, then the rank
| will be the same.
|
| Any help will be highly appreciated.
|

Maybe you should post in a SQL Server group not in an Oracle one.

Regards
Michel Cadot Received on Tue Feb 07 2006 - 12:16:59 CST