Let say there is an Course Table -
Couse_Details -
Couse_Id, CouseName, Instructor_id, Student_id, Enroll_dt
How Do i find out details of students i.e. student_id who are enrolled in all courses in 2015.
Example - if 2015 has 3 courses C1,C2,C3 - then I want students who have enrolled in all C1,C2 and C3 and no more or no less.
I tried using subquery with partitioning clause. but unable to get the result.