SELECT * FROM TBL_COURSESCORE c WHERE c.COURSE_ID IN (
SELECT s.COURSE_ID FROM TBL_COURSESCORE s WHERE
s.STUDENT_ID = '2012541024'
GROUP BY
s.COURSE_ID
HAVING
COUNT (1) > 1
)
AND c.STUDENT_ID = '2012541024'
SELECT s.COURSE_ID FROM TBL_COURSESCORE s WHERE
s.STUDENT_ID = '2012541024'
GROUP BY
s.COURSE_ID
HAVING
COUNT (1) > 1
)
AND c.STUDENT_ID = '2012541024'