SELECT
*
FROM
`education_student_tmp_from_crp` a
WHERE
(a.stu_no) IN (
SELECT
stu_no
FROM
`education_student_tmp_from_crp`
GROUP BY
stu_no
HAVING
COUNT(*) > 1
)
SELECT
*
FROM
`education_student_tmp_from_crp` a
阅读背景：
mysql查找一个表中字段相同的数据
来源：互联网
分享到：
