-- 12、查询至少有一门课与学号为“01“的同学所学相同的同学的信息

科技2022-07-20 97

SELECT DISTINCT st.* FROM student st LEFT JOIN score sc ON sc.s_id=st.s_id WHERE sc.c_id IN ( SELECT 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