mysql 多字段 去重

mysql 多字段 去重,

DELETE
FROM
	stock_a_info
WHERE
	(stock_code,data_time) IN (
		SELECT
			t.stock_code,
			t.data_time
		FROM
			(
				SELECT
					stock_code,
					data_time
				FROM
					stock_a_info
				GROUP BY
					stock_code,
					data_time
				HAVING
					count(1) > 1
			) t
	)
AND id NOT IN (
	SELECT
		dt.mindeptno
	FROM
		(
			SELECT
				min(id) AS mindeptno
			FROM
				stock_a_info
			GROUP BY
					stock_code,
					data_time
			HAVING
				count(1) > 1
		) dt
)