Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rank Based on Three Columns
Mr.C wrote:
>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.
>
>
>
Perhaps you might get a better response to your SQL Server question in a
SQL Server newsgroup. As you may have noticed from its name, this is an
Oracle group. :)
Received on Tue Feb 07 2006 - 12:18:52 CST