Please can someone give me the TSQL statement to find duplicate records
using 2 or more fields as a group;

ie:  duplicate course records for students who have taken a course more than
once

select student_id, course_id from coursetable
group by ???? having count(???) > 1

thank you in advance for your help

vas chellappa