如何利用row_number函数处理重复数据

CREATE TABLE person(
    sn varchar(10),
    name varchar(50)
);
go

insert into person values("1","guoqiang1");
insert into person values("1","guoqiang1");
insert into person values("1","guoqiang1");
insert into person values("2","guoqiang2");
insert into person values("2","guoqiang2");
insert into person values("3","guoqiang3");
go

select * from dbo.person;
go

select sn,name into tmp from 
(select *, row_number() over(partition by sn order by sn) 
as rank from person) as t
where t.rank = 1
go

select * from dbo.tmp
go