设有关系模式SCsnocnograde查询既选修了c1又选修了c2课程的学生学号正确的SQL命令是-X题卡

设有关系模式SCsnocnograde查询既选修了c1又选修了c2课程的学生学号正确的SQL命令是

SELECT sno FROM sc WHERE cno=“c1”AND cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”UNION SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND sno IN(SELECT sno FROM sc WHERE cno=“c2”)

设有关系模式SCSnoSnameSexBirthdayCnoCnameGradeTnoTname满

（Sno,Tno）和{Cno,Cname,Grade,Tno,Tname} （Sno, Cno, Tno）和{Sno, Sname, Sex, Birthday, Cno} （Sno, Cno）和{Sno, Sname, Sex, Birthday, Cno, Cname, Grade} （Sno, Cno, Tno）和{Sno, Sname, Sex, Birthday, Tno, Tname}

已知学生选课信息表scsnocnograde查询至少选修了一门课程但没有学习成绩的学生学号和课程号的

SELECT sno，cno FROM sc WHERE grade=NULL SELECT sno，cno FROM sc WHERE grade IS‘’ SELECT sno，cno FROM sc WHERE grade IS NULL SELECT sno，cno FROM sc WHERE grade=‘’

设有关系模式SCSnoSnameSexBirthdayCnoCnameGradeTnoTname满

(Sno,Tno)和Cno,Cname,Grade,Tno,Tname (Sno, Cno,Tno) 和Sno, Sname, Sex, Birthday, Cno (Sno, Cno)和Sno, Sname, Sex, Birthday, Cno, Cname, Grade (Sno, Cno,Tno)和Sno, Sname, Sex, Birthday, Tno, Tname

设有关系模式SCsnocnograde各属性含义依次是学号课程号分数要查询没有成绩的学生学号正确的S

设有关系SSNOSNAMESEXCCNOCNAMESCSNOCNOGRADE其中SNO为学生号SNA

SNO＝SC.SNO and SEX＝'女'and CNAME＝'计算机' SNO=SC.SNO and C.CNO＝SC.CNO and CNAME＝'计算机' SEX='女'and CNAME='计算机' SNO＝SC.SNO and C.CNO＝SC.CNO and SEX='女'and CNAME='计算机'

设有关系SCSNOCNOGRADE其中SNOCNO分别表示学号和课程号两者均为字符型GRADE表示成

INSERT INTO SC(SNO,CNO,GRADE)VALUES(′S1 01′,′C11′,′98′) INSERT INTO SC(SNO,CNO,GRADE)VALUES(S101,C11,98) INSERT(′S101′,′C11′,′98′)INTO SC INSERT INTO SC VALUES(′S101′,′C11′,98)

设有关系模式SCsnocnograde各属性含义依次是学号课程号分数要查询分数低于60分的学生学号正

SEI，ECT sno FROM SC WH ERE grade BETWEEN O AND 60 SELECT sno FROM SC WHERE grade＜60 SELECT sno FROM SC HAVlNG grade BETWEEN O AND 60 SELECT sno FROM SC HAVING grade＜60

设有关系模式SCsnoenograde查询既选修了c1又选修了c2课程的学生学号正确的SQL命令是

SELECT sno FROM sc WHERE cno="c1"AND cno="c2" SELECT sno FROM sc WHERE cno="cl'，AND SELECT sno FROM sc WHERE cno="c2" SELECT sno FROM sc WHERE cno="cl" UNION SELECT sno FROM sc WHER：E cno="c2" SELECT sno FROM sc WHERE cno="cl"AND sno IN(SELECT sno FROM sc WHERE cno="c2")

设有关系模式SCsnoenograde查询既选修了c1又选修了c2课程的学生学号正确的SQL命令是

SELECT sno FROM sc WHERE cno="c1"AND cno="c2"  SELECT sno FROM sc WHERE cno="cl'，AND SELECT sno FROM sc WHERE
cno="c2"  SELECT sno FROM sc WHERE cno="cl" UNION SELECT sno FROM sc WHER：E
cno="c2"  SELECT sno FROM sc WHERE cno="cl"AND sno IN(SELECT sno FROM sc WHERE
cno="c2")

设有关系模式SCsnocnograde各属性含义依次是学号课程号分数将关系SC中所有选修课程号为‘D

ALTER TABLE SC SET GRADE+10 WHERE CNO='DB' ALTER TABLE SC SET GRADE=GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE=GRADE+10 WHERE CNO='DB'

23～24题基于以下说明设有三个关系学生关系SSNOSNAMEAGESEX分别代表学生的学号姓名年龄

SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE DETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′OR GRADE BETWEEN 60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE＞=60 AND 90 SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE＜=60 AND GRADE＞=90

设有关系模式SCSnoSnameSexBirthdayCnoCnameGradeTnoTname满足

(Sno,Tno)和{Cno,Cname,Grade,Tno,Tname} (Sno, Cno,Tno) 和{Sno, Sname, Sex, Birthday, Cno} (Sno, Cno)和{Sno, Sname, Sex, Birthday, Cno, Cname, Grade} (Sno, Cno,Tno)和{Sno, Sname, Sex, Birthday, Tno, Tname}

设有关系模式SCsnocnograde各属性含义依次是学号课程号分数将关系SC中所有选修课程号为'D

ALTER TABLE SC SET GRADE+10 WHERE CNO='DB' ALTER TABLE SC SET GRADE=GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE+10 WHERE CNO='DB' UPDATE SC SET GRADE=GRADE+10 WHERE CNO='DB'

设有关系SCSNOCNOGRADE其中SNOCNO分别表示学号课程号两者均为字符型GRADE表示成绩

已知学生选课信息表scsnocnograde查询至少选修了一门课程但没有学习成绩的学生学号和课程号的

SELECT sno，cno FROM sc WHERE grade=NULL SELECT sno，cno FROM sc WHERE grade IS‘’ SELECT sno，cno FROM sc WHERE grade IS NULL SELECT sno，cno FROM sc WHERE grade=‘’

设有关系模式SCSnoSnameSexBirthdarCnoCnameGradeTnoTname满足

(Sno，Tno)和Cno，Cname，Grade，Tno，Tname (Sno，Cno，Tno)和Sno，Sname，Sex，Birthday，Cno (Sno，Cno)和Sno，Shame，Sex，Birthday，Cno，Cname，Grade (Sno，Cno，Tno)和Sno，Sname，Sex，Birthdayr，Tno，Tname

已知学生选课信息表scsnocnograde查询至少选修了一门课程但没有学习成绩的学生学号和课程号的

SELECT sno，cno FROM sc WHERE grade=NULL SELECT sno，cno FROM sc WHERE grade IS" SELECT sno，cno FROM sc WHERE grade IS NULL SELECT sno，cno FROM sc WHERE grade=''

设有关系模式SC（sno，cno，grade），查询既选修了c1又选修了c2课程的学生学号，正确的SQL命令是（）。

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库