mysql 查询重复记录获取id:

SELECT a.id FROM ( SELECT id,zlcode,COUNT(*) AS COUNT FROM zlinfo WHERE zlcode>0 GROUP BY zlcode HAVING COUNT>1 ORDER BY id DESC) AS a;

 

mysql查询重复记录并删除

DELETE FROM zlinfo WHERE id IN(SELECT a.id FROM ( SELECT id,zlcode,COUNT(*) AS COUNT FROM zlinfo WHERE zlcode>0 GROUP BY zlcode HAVING COUNT>1 ORDER BY id DESC) AS a);