m0_57988018的博客

检索所学课程包含学生‘张向东’所学课程的学生学号、姓名；select distinct student.sno,student.snamefrom student,scwhere student.sno = sc.sno and sc.cno in(select sc.cnofrom student,scwhere student.sno = sc.sno and student.sname = '张向东')；结果：2.使用嵌套查询列出选修了“数据结构”课程的学生学号和姓.