已知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