CREATE TABLE person( sn varchar(10), name varchar(50));go
插入測(cè)試重復(fù)數(shù)據(jù)
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
去除重復(fù)數(shù)據(jù)，并放到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
