create table a ( zjlbbm varchar(20) , zjxm_name varchar(20) ) goinsert into a(zjlbbm,zjxm_name) values('01','z01') insert into a(zjlbbm,zjxm_name) values('02','z01') insert into a(zjlbbm,zjxm_name) values('03','z01') insert into a(zjlbbm,zjxm_name) values('04','z02') insert into a(zjlbbm,zjxm_name) values('05','z03') insert into a(zjlbbm,zjxm_name) values('06','z03')select zjlbbm,id=identity(int,1,1),zjxm_name into #t from aselect * from #tdelete #t from ( select min(id) as id,zjxm_name from #t group by zjxm_name ) as no1 where #t.zjxm_name = no1.zjxm_name and #t.id > no1.id drop table #t
(
zjlbbm varchar(20) ,
zjxm_name varchar(20)
)
goinsert into a(zjlbbm,zjxm_name) values('01','z01')
insert into a(zjlbbm,zjxm_name) values('02','z01')
insert into a(zjlbbm,zjxm_name) values('03','z01')
insert into a(zjlbbm,zjxm_name) values('04','z02')
insert into a(zjlbbm,zjxm_name) values('05','z03')
insert into a(zjlbbm,zjxm_name) values('06','z03')select zjlbbm,id=identity(int,1,1),zjxm_name into #t from aselect * from #tdelete #t
from
( select min(id) as id,zjxm_name from #t group by zjxm_name
) as no1
where #t.zjxm_name = no1.zjxm_name
and #t.id > no1.id
drop table #t
delete TableName where FileName=bb
insert into tableName select * from #tmp