-- 查询重复的数据
SELECT * from (SELECT *, CONCAT(字段1,字段2) as commonData from A表) t WHERE commonData in
(
SELECT commonData from (SELECT CONCAT(字段1,字段2) as commonData from A表 ) tt GROUP BY commonData HAVING count(commonData ) > 1
)
-- 删除重复的数据,并保留id值最大的一条
DELETE from A表 WHERE id not in
(
SELECT maxId from (SELECT MAX(id) as maxId, CONCAT(字段1,字段2) as commonData from A表 GROUP BY commonData ) t
)