A、SELECT SN,AGE,SEX FROM S
SHERE AGE>(SELECT AGE FROM S)
WHERE SN=’王华’)
B、SELECT SN,AGE,SEX
FROM S
WHERE SN=’王华’
C、SELECT SN,ACE,SEX FROM S
WHERE AGE>(SELECT ACE
WHERE SN=’王华’)
D、SELECT SN,ACE,SEX FROM S
WHERE ACE>王华AGE
第1题:
S(S#,SN,SEX,AGE,DEPT)
C(C#,CN)
SC(S#,C#,GRADE)
其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号, CN为课程名,GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别:正确的SELECT语句是______。
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
第2题:
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。
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题:
现有三个表:学生表S、课程表C和学生选课表SC,表结构如下: S(Sno, Sname,SEX,AGE,DEPT) C(Cno, Cname) SC(Sno,Cno,GRADE) 检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______
A.SELECT sname,age,sex FROM s WHERE sname=‘王华‘
B.SELECT sname,age,sex FROM s WHERE age;王华.age
C.SELECT sname,age,sex FROM s WHERE age;(SELECT age;;FROM s;;WHERE sname=‘王华‘)
D.SELECT sname,age,sex FROM s WHERE age;(SELECT age;; WHERE sname=‘王华‘)
第4题:
已知基本表:学生(学号,姓名,性别,年龄,系名)
选课(学号,课程号,成绩)
要检索所有比“王华”年龄大的学生姓名、年龄和性别,正确的语句是(25),要检索学生姓名及其所选修课程的课程号和成绩,正确的语句是(26)。
A.SELECT姓名,年龄,性别 FROM学生 WHERE AGE>(SELECT年龄 FROM学生 WHERE姓名=“王华”)
B.SELECT姓名,年龄,性别 FROM学生 WHERE姓名:“王华”
C.SELECT姓名,年龄,性别 FROM学生 WHERE AGE>(SELECT年龄 WHERE姓名=“王华”)
D.SELECT姓名,年龄,性别 FROM学生 WHERE AGE>“王华”
第5题:
现有学生表S、课程表C和学生选课表SC,它们的关系模式如下。 S(S#,SN,SEX,AGE,DEPT)(学号,姓名,性别,年龄,系别); C(C#,CN)(课程号,课程名称); SC(S#,C#,GRADE)(学号,课程号,成绩)。 检索所有比“王华”年龄大的学生姓名、年龄和性别。下面正确的SELECT语句是()。
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