单选题:检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是:
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是:
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
答案:B
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
答案:B