Mysql去重sql

替换变量table_name 和 group_by

DELETE
FROM
	${table_name}
WHERE ID NOT IN (
	SELECT	
	*	
	FROM
	(
		SELECT
			Max(ID)
		FROM
	    	${table_name}
		GROUP BY
			${group_by}
	
    ) bb
)