34,838
社区成员




create table tb(bh varchar(20),xm varchar(10))
insert into tb select '0001','王明'
insert into tb select '0001','王明'
insert into tb select '0002','张华'
insert into tb select '0003','王平'
insert into tb select '0003','王平'
select * into # from (select distinct * from tb)tp
delete tb
insert into tb select * from #
select * from tb