SQL 找出一字段中所有重复的记录

SELECT r.student_id FROM results r

group by r.student_id

having count(r.student_id)>1;