• 2022-06-09 问题

    针对上一题中的关系,查询至少选修了“201715002”同学所选课程的学生的姓名,可以使用如下SQL语句。select sname from swhere sno[]‘201715002’ and not exists (select * from sc x where x.sno='201715002' and not exists (select * from sc y where y.cno=x.cno and y.sno=s.sno ) )

    针对上一题中的关系,查询至少选修了“201715002”同学所选课程的学生的姓名,可以使用如下SQL语句。select sname from swhere sno[]‘201715002’ and not exists (select * from sc x where x.sno='201715002' and not exists (select * from sc y where y.cno=x.cno and y.sno=s.sno ) )

  • 1