delete from testname2
where checksum(name1,name2) =
(select distinct checksum(name1,name2) from testname2
group by checksum(name1,name2)
having COUNT(*)>1)
删除表中, 列属性完全相同的记录
delete from testname2
where checksum(name1,name2) =
(select distinct checksum(name1,name2) from testname2
group by checksum(name1,name2)
having COUNT(*)>1)
删除表中, 列属性完全相同的记录