学步园

select 
  id=row_number() over(oder by value desc),
  *
from tb
order by value desc

select 
  id=(select count(1) from tb where value>t.value),
  *
from tb t
order by value desc

  Select ID=Identity(int,1,1),* Into #temptable From #tb Order By Value
  Select * From #temptable 
  Drop Table #temptable