Thesewinnersfromthatkeyschoolarewiseanddiligentact-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”)

WinnersClub!Youchoosetobeawinner!TheWinnersClubisa

TheWinnersClubisabankaccountspeciallydesignedforte

WinnersClubYouchoosetobeawinner!TheWinnersClubisab

从学生选课信息表中找出无成绩的元组的SQL语句是

SELECT * FROM sc WHERE grade=NULL SELECT *FROM sc WHERE grade IS'' SELECT *FROM sc WHERE grade IS NULL SELECT *FROM sc WHERE grade=''

Youchoosetobeawinner!TheWinnersClubisabankaccounts

TheWinnersClubisabankaccountspeciallydesignedforte

WinnersClubYouchoosetobeawinner!TheWinnersClubisab

查询选修了课程号为MATHS的学生的姓名和年龄若用下列SQL的SELECT语句表达时错误的是

SELECT SNAME,AGE FROM S WHERE S.S#=(SELECT SC.S#}FROM SC WHERE C.C#='MATHS') SELECT SNAME,AGEFROM SWHERE S.S#=(SELECT SC.S#}FROM SC WHERE SC.C#='MATHS') SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS' ORDER BY S.S# SELECT SNAME,AGE FROM S, SC WHERE S.S#=SC.S# AND SC.C#='MATHS'

设有关系模式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")

WinnersClubYouchoosetobeawinner!TheWinnersClubisab

TheWinnersClubisabankaccountspeciallydesignedforte

WinnersClubYouchoosetobeawinner!TheWinnersClubisab

已知基本表SCS#C#GRADE则统计选修了课程的学生人次数的SQL语句为

SELECT COUNT(DISTINCTS#)/FROM SC SELECT COUNT(S#)/FROM SC SELECTCOUNT(*)/FROM SC SELECT COUNT (DISTINCT*)/FROM SC

TheWinnersClubisabankaccountspeciallydesignedforte

Thesewinnersfromthatkeyschoolarewiseanddiligentact

WinnersClubYouchoosetobeawinner!TheWinnersClubisab

从学生选课信息表中找出无成绩的元组的SQL语句是

SELECT*FROM sc WHERE grade＝NULL SELECT*FROM sc WHERE grade IS" SELECT*FROM sc WHERE grade IS NULL SELECT*FROM sc WHERE grade=/

己知基本表SCS#C#GRADE则统计选修了课程的学生人次数的SQL语句为

SELECT COUNT(DISTINCT S#)FROM SC SELECT COUNT(S#)FROM SC SELECT COUNT(*)FROM SC SELECT COUNT(DISTINCT)FROM SC

These winners from that key school are wise and diligent, actually there are ______students in that ...

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库