SELECT st.*
FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
GROUP BY st.s_id
HAVING GROUP_CONCAT(sc.c_id) =
(
SELECT
GROUP_CONCAT(sc2.c_id)
FROM student st2
LEFT JOIN score sc2 ON sc2.s_id=st2.s_id
WHERE st2.s_id ='01'
)
Processed:
0.010, SQL:
8
