MySQL多字段去重

功能描述

对多个字段进行去重操作，即删除A、B、C三个字段都相同的重复数据。
其中id留最大值

SQL

DELETE FROM ${tableName} 
WHERE id not in (SELECT id FROM (
	SELECT max(${tn}.id) as id 
	from ${tableName} ${tn}
	group by 
	    ${tn}.A,
	    ${tn}.B,
	    ${tn}.C
	ORDER BY ${tn}.id DESC
) AS t);

适用范围

MySql

---

作者：@黑色的白兔子

邮箱：0500aa@protonmail.com