SQL Server排序函数row_number和rank的区别

直接看测试结果

declare @table table(name varchar(100),amount int, memo varchar(10))insert into @table(name,amount,memo)values('apple',8,'123'),('apple',10,'123'),('apple',12,'235'),('orange',11,'123'),('orange',14,'123'),('pear',9,'123')

row_number

select row_number()over(order by name) as rn,* from @table

rank

select rank()over(order by name) as rn,* from @table