成人高等教育 / 数据库应用技术
正确率:100%
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的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
参考答案:
佳题速递: