仅为个人理解,有空请参观迷恋自留地
(直接使用2就好,idd为主键,没有的话自己添加,id是带有重复值的列)
- sql 查询某个字段值相同
select id,COUNT(*) from oneyan group by id having count(*) > 1
- sql 查询某个字段值相同及其删除多余值保留不重复那个
delete oneyan where idd not in
( select min(idd) from oneyan group by id)