第1题
A、SELECT SN,AGE,SEX FROM S WHERE SN=“王华”
B、SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=“王华”)
C、SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=“王华”)
D、SELECT SN,AGE,SEX FROM S WHERE AGE>王华.AGE
第2题
A、SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN="王华")
B、SELECT SN,AGE,SEX FROM S WHERE SN="王华"
C、SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN="王华")
D、SELECT SN,AGE,SEX FROM S WHERE AGE > 王华.AGE
第3题
第4题
有 这样三个表:学生表S、课程表C和学生选课表SC,它们的结构如下:S(S#,SN,SEX,AGE,DEPT)、C(C#,CN)、 SC(S#,C#,GRADE)。其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,CN为课程名,GRADE 为成绩。要求如下:检索选修课程"C2"的学生中成绩最高的学生的学号。正确的SELECT语句是()。
A、SELECT S# FROM SC WHERE C#="C2" AND GRADE>=(SELECT GRADE FROM SC WHERE C#="C2")
B、SELECT S# FROM SC WHERE C#="C2" AND GRADE>(SELECT GRADE FROM SC WHERE C#="C2")
C、SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2")
D、SELECT S# FROM SC WHERE C#="C2" AND GRADE=(SELECT MAX(GRADE)FROM SC WHERE C#="C2")
第5题
第6题
第7题
A、SELECT SN,AGE,SEX FROM S WHERE AGE<(select age from s where sn="王华"> B、SELECT SN,AGE,SEX FROM S WHERE SN='王华'
C、SELECT SN,AGE,SEX FROM S WHERE AGE<(select age where sn="王华"> D、SELECT SN,AGE,SEX FROM S WHERE SGE<王华.age<br>
第8题
A. SELECT SN,AGE,SEX FROM SWHE RESN=“王华”
B. SELECT SN,AGE,SEX FROM SWHE REAGE>(SELECTAGEFROMSWHERESN=“王华”)
C. SELECT SN,AGE,SEX FROM SWHE REAGE>(SELECTAGEWHERESN=“王华”)
D. SELECT SN,AGE,SEX FROM SWHE REAGE>王华.AGE
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!