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
查看person表
select * from dbo.person;go
去除重復數據，并放到tmp表中
select sn,name into tmp from (select *, row_number() over(partition by sn order by sn) as rank from person) as twhere t.rank = 1go
