相関サブクエリで連番を振る

SQLserver

SQLserverで「rownum」が使えれば簡単なんだけど＞＜

select
  (
  select count(COLUMN) from TABLE_B as B
  where B.COLUMN <= A.COLUMN
  ) as Rank
,
* from TABLE_A as A
order by Rank ASC
;