mysql数据去重

mysql表中存在多条相同数据，去重方法。

mysql的delete有以下几个语法注意：

1、不支持limit

2、不支持子查询

 

SELECT * FROM bank_info c
WHERE id IN 
(
	SELECT * FROM 
	(
		SELECT id FROM bank_info a  
		WHERE 
		(
			a.bank_num IN (SELECT bank_num FROM bank_info GROUP BY bank_num HAVING COUNT(*) > 1) 
			AND 
			a.create_time NOT IN (SELECT MIN(create_time) FROM bank_info GROUP BY bank_num HAVING COUNT(*) > 1)
		)
	) e
)