0)
select distinct * into #Tmp from tes1
truncate table tes1
select * into tes1 from #Tmp
drop table #Tmp
1)
select * from (
select
t.*, row_number() over(partition
by
字段,字段
order
by
条件
desc
) lev from tb t
) tt where tt.lev=1;
--条件可以是时间,也可以是ID,等等
2)
select hospital_name,hospital_address from gz_hospital group by hospital_name,hospital_address having count(hospital_name)>1
3)
1 | //查询出唯一数据的ID,并把他们导入临时表tmp中 |
2 | select min (id) as mid into tmp from 表 group by mobilePhone,officePhone,email |
3 |
4 | //查询出去重后的数据并插入finally表中 |
5 | insert into finally select (除ID以外的字段) from customers_1 where id in ( select mid from tmp) |