|
查詢重復(fù)記錄 select * from idc_aqzrr where dwmc in (select dwmc from idc_aqzrr group by dwmc having count(dwmc) > 1) ========================================= 刪除重復(fù)記錄 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 ) |
|
|
