欢迎来到PP题库网 PP题库官网
logo

单项选择题

对于教学数据库的三个基本表:S(Sno,Sname,Ssex),SC(Sno,Cno,Grade),C(Cno,Cname,Teacher),其中S表为学生表,SC为学生选课表,C为课程表,则对于语句:检索至少选修LIU老师所授课程中一门课程的女生姓名,SQL语句错误的是______。

    A.SELECT SnameFROM S,SC,CWHERE S Sno=SC.Snn AND SC.Con=C.Con And Teacher="LTU" AND Seex="F"
    B.SELECT SnameFROM S WHERE Ssex="F" AND Sno IN(SELECT SnoFROM SCWHERE(Cno IN(SELECT Cno FROM CWHERE Teacher="LIU"))
    C.SELECT SnameFROM S WHERE Ssex="F" AND EXISTS(SELECT*FROM SCWHEPE SC.Sno=S. Sno AND EXISTS(SELECT*FROM CWHERE Teacher="LIU"))
    D.SELECT SnameFROM S WHEPE Ssex="F" AND EXISTS(SELECT*FROM SCWHERE SC.Sno=S.Sno AND EXISTS(SELECT*FROM CWHERE C Cno=SC Cno AND Teacher="LIU"))
点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题