SQL 找出一字段中所有重複的記錄

SELECT r.student_id FROM results r

group by r.student_id

having count(r.student_id)>1;