sql server排名函数分别是:row_number、rank、 dense_rank
row_number:顺序生成序号。
rank:相同的序值序号相同,但序号会跳号。
dense_rank :相同的序值序号相同,序号顺序递增。
例如:
select row_number() over(order by amount) as row_number,* from table
select rank() over(order by amount),* from table order by amount
select dense_rank() over(order by amount),* from table order by amount