查询至少学过学号为 “s001” 同学所有一门课的其他同学学号和姓名; 相关知识点: 试题来源: 解析 select * from sc left join student st on st.sno=sc.sno where sc.sno's001' and sc.cno in (select cno from sc where sno='s001') 反馈 收藏 ...