Query to Find the Student ids by group
955544Oct 22 2012 — edited Oct 22 2012Hi,
I have a table which has 2 columns student_id and Course_id.
Sample Data
Student_id Course_id
-------------------------------
1 --> 1
1 --> 2
1 --> 3
1 --> 4
2 --> 1
2 --> 3
3 --> 1
3 --> 2
3 --> 4
I want to find those students who have taken all the courses 1,3,4.