【单选题】Just read something to kill time, a book, a magazine, newspaper, or .
【简答题】Just read something to kill time, a book, a magazine, newspaper, or anything like that.
【单选题】基于这样的三个表即学生表ST、课程表CO和学生选课表SC,它们的结构如下:ST(S_ID,SN,SEX,AGE,DEPT),CO(C_ID,CN),SC(S_ID,C_ID,GRADE)。其中:.S_ID为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C_ID为课程号,CN为课程名,GRADE为成绩。检索所有比“张岩”年龄大的学生姓名、年龄和性别。正确的SELECT语句是____.
A.
SELECT SN,AGE,SEX FROM ST WHERE AGE>(SELECT AGE FROM ST WHERE SN="张岩")
B.
SELECT SN,AGE,SEX FROM ST WHERE SN="张岩"
C.
SELECT SN,AGE,SEX FROM ST WHERE AGE>(SELECT AGE WHERE ="张岩")
D.
SELECT SN,AGE,SEX FROM ST WHERE AGE>张岩.AGE