已知S(S#,SN,AGE,SEX),S#学号,SN姓名,AGE年龄,SEX性别。若要检索所有比‘‘年龄大的学生姓名、年龄和性别,正确的SQL语句是( )
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