数据库中如果插入重复记录，需要有效排查出重复结果

更多精彩

• 更多技术博客，请移步

方法

SELECT 	* FROM 	pt_university_institute_staffWHERE 	staffId IN (		SELECT 			co.staffId 		FROM (			SELECT 				staffId, count(*) AS count 			FROM 				pt_university_institute_staff 			GROUP BY 				staffId 			HAVING 				count > 1		) co	);