删除表中的重复记录

--先向表中插入数据.

insert into dbo.EmployerInfo(name,age,sex) values('孔新林',25,'男')
insert into dbo.EmployerInfo(name,age,sex) values('孔新林',25,'男')
insert into dbo.EmployerInfo(name,age,sex) values('董永',25,'男')
insert into dbo.EmployerInfo(name,age,sex) values('董永',25,'男')

 

 

 

--查看当前记录
select * from dbo.EmployerInfo

if object_id('#tb') is not null
  drop table #tb
--注意(是单个字段的不同还是多个字段,这里是name)
select distinct [name],age,sex into #tb from dbo.EmployerInfo
--查看新表中的数据
select * from #tb
--清空旧表
truncate table dbo.EmployerInfo
--将新表中的数据插入到旧表
insert dbo.EmployerInfo select [name] ,age,sex from #tb
--删除新表
drop table #tb
--查看结果
select * from dbo.EmployerInfo