使用此除重语句似乎目前为止是效率最高的,实行条件,具有可比性的唯一约束 create table #tb ( ID int identity(1,1), Slopeno varchar(30), LocationCode varchar(30), VDatetime Datetime ) insert into #tb (Slopeno,LocationCode,VDatetime) select 'A','011','2010-10-10' union all select 'A','012','2010-10-11' union all select 'A','013','2010-10-14' union all select 'B','014','2010-10-15' union all select 'C','015','2010-10-16' select * from #tb delete from #tb where exists(select null from #tb B where #tb.Slopeno=B.Slopeno and #tb.ID < B.ID) select * from #tb