MySql 直接删除表中多余的重复数据,只保留id最小的数据 SELECT * FROM tq_whitelist WHERE advisor_id IN ( SELECT advisor_id FROM tq_whitelist GROUP BY advisor_id HAVING COUNT(1)>1 ) AND id NOT IN ( SELECT MIN(id) FROM tq_whitelist GROUP BY advisor_id HAVING COUNT(1)>1 )