删除重复的数据且保留id最小的数据

DELETE
FROM
	credit_order_gray
WHERE
	id_card IN (
		SELECT
			*
		FROM
			(
				SELECT
					id_card
				FROM
					credit_order_gray
				GROUP BY
					id_card
				HAVING
					count(id_card) > 1
			) AS t1
	)
AND id NOT IN (
	SELECT
		*
	FROM
		(
			SELECT
				MIN(id)
			FROM
				credit_order_gray
			GROUP BY
				id_card
			HAVING
				count(id_card) > 1
		) AS t2
);

注意务必为每个子查询给定alias表名。