asigning numerical values to rows

T

tim h

I have writen a query called Chg-Base which looks like
this:

OperationCode ProcedureCode AdditionalFee
1 49561 $210
1 30111 $210
1 48933 $134
1 39944 $59

I have the "AdditionalFee" sorted into descending order.
I want to create another column that gives each row a
numerical value which corresponds to the record number.
I suppose this is like ranking them, but in the case of
an "AdditionFee" tie, I want the row number to continue
increasing by one.

ie:

OperationCode ProcedureCode AdditionalFee Number
1 49561 $210 1
1 30111 $210 2
1 48933 $134 3
1 39944 $59 4

Can anyone help me?
 
Top