mysql查询重复字符串字段的条目

需求：培训人员名单列表有批量导入功能，未做严谨过滤时，出现身份证号重复记录，需要查出重复记录做删除。

mysql语句：

   SELECT b.*
	 FROM (
		SELECT idCardNo, count(1) AS i
		  FROM tal
	  GROUP BY idCardNo
		HAVING i > 1
		) AS a
LEFT JOIN tal b ON b.idCardNo = a.idCardNo