题目内容:
设有学生表S(学号,姓名,性别,年龄),查询所有年龄小于等于18岁的女同学,并按年龄进行降序生成新的表WS,正确的SQL命令是
A.SELECT*FROMSWHERE性别='女'AND年龄<=18ORDERBY4DESCINTOTABLEWS B.SELECT*FROMSWHERE性别='女'AND年龄<=18ORDERBY年龄INTOTABLEWS
C.SELECT*FROMSWHERE性别='女'AND年龄<=18ORDERBY‘年龄’DESCINTOTABLEWS
D.SELECT*FROMSWHERE性别='女'OR年龄<=18ORDERBY‘年龄’ASCINTOTABLEWS
参考答案:
答案解析: