A、
B、
C、
D、
A、
B、
C、
D、
A.ПCNAME, GRADE (σCNAME=’数据库技术’(C) ∞ПSNO, CNO, GRADE (SC) ∞ПSNO, SNAME (S) )
B.ПCNAME, GRADE (σCNAME=’数据库技术’(C) ∞ SC ∞ S)
C.ПCNAME, GRADE (C ∞ SC ∞ SC)
D.ПCNAME, GRADE (σCNAME=’数据库技术’ (ПCNAME (C)) ∞ПSNO, CNO, GRADE (SC) ∞ПSNO, SNAME (S) )
A、πS#,C#(SC)÷πC#(σTNAME='LIU'(SC)) SELECT DISTINCT S# FROM SC AS X WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND NOT EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
B、πS#,C#(SC)÷πC#(σTNAME='LIU'(C)) SELECT DISTINCT S# FROM SC AS X WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND NOT EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
C、πS#,C#(SC)÷πC#(σTNAME='LIU'(C)) SELECT DISTINCT S# FROM SC AS X WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
D、πS#,C#(SC)÷πC#(σTNAME='LIU'(C)) SELECT DISTINCT S# FROM SC WHERE NOT EXISTS (SELECT * FROM C WHERE TNAME=’LIU’ AND EXISTS (SELECT * FROM SC AS Y WHERE Y.S#=X.S# AND Y.C#=C.C#));
A、(Stid, Cno)
B、Stid
C、Cno
D、GRADE
A、SELECT S.SName FROM S JOIN SC JOIN C ON S.SNO = SC.SNO AND SC.CNO = C.CNO WHERE S.Class='经统2018-1' AND C.CName = '数据库'
B、SELECT S.SName FROM S JOIN SC ON S.SNO = SC.SNO JOIN C ON SC.CNO = C.CNO WHERE S.Class='经统2018-1' AND C.CName = '数据库'
C、SELECT S.SName FROM S JOIN SC JOIN C WHERE S.Class='经统2018-1' AND C.CName = '数据库' AND S.SNO = SC.SNO AND SC.CNO = C.CNO
D、SELECT S.SName FROM S JOIN C ON S.SNO = C.CNO JOIN SC ON SC.SNO = S.SNO AND SC.CNO = C.CNO WHERE S.Class='经统2018-1' AND C.CName = '数据库'
学生关系S(SNO,SNAME,AGE,SEX)(分别代表学生的学号、姓名、年龄、性别)
学习关系SC(SNO,CNO,GRADE)(分别代表学生的学号、课程编号、成绩)
课程关系C(CNO,CNAME,TEACHER)(分别代表课程的编号、课程名、任课教师)
“从学习关系SC中检索无成绩的学生学号”的SQL语句是
A.SELECT sno FROM sc WHERE grade=NULL
B.SELECT sno FROM sc WHERE grade IS
C.SELECT sno FROM sc WHERE grade IS NULL
D.SELECT sno FROM sc WHERE grade=0
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!