已知S(S#,SN,AGE,SEX),S#是,SN是姓名。若要检索所有比年龄大的学生姓名、年龄和性别,正确的 SELECT语句是()
A.
SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN='')
B.
SELECT SN,AGE,SEX FROM S WHERE AGE>''
C.
SELECT SN,AGE,SEX FROM S WHERE AGE>''.AGE
D.
SELECT S1.SN,S1.AGE,S1.SEX FROM S S1, S S2 WHERE S1.SN='' AND S2.AGE>S1.AGE