现有三个表:学生表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位网友选择 C,占比44.44%
- · 有3位网友选择 B,占比33.33%
- · 有2位网友选择 A,占比22.22%