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
