|
查询重复记录 select * from idc_aqzrr where dwmc in (select dwmc from idc_aqzrr group by dwmc having count(dwmc) > 1) ========================================= 删除重复记录 delete from idc_yhsbxx where id not in ( select a2.min_id from ( select min(id) as min_id from idc_yhsbxx group by dwmc) as a2 ) |
|
|
