Increment / Rank in SQL
Posted on 2004-10-07
I have table with a list of values in it
I want to update a column called Rank
But this is not a true rank column - because I do not want this to happen
I want this result
I want to try and avoid adding it as an auto incrementing column - means I have to order by and insert the values into a new table.
Does anyone have a solution as to how I can do this.
I have code to Rank but like I said that is not actually what we need.