题目内容:
设有学生表S(学号,姓名,性别,年龄),查询所有年龄小于等于18岁的女同学、并按年龄进行降序排序生成新的表WS,正确的SQL命令是( )。
A.SELECT*FROM S WHERE性别=ˋ女ˊAND年龄<=18 OREDER BY 4 DESC INTO TABLE WS B.SELECT*FROM S WHERE性别=ˋ女ˊAND年龄<=18 OREDER BY年龄INTO TABLE WS
C.SELECT*FROM S WHERE性别=ˋ女ˊAND年龄<=18 OREDER BYˋ年龄ˊDESC INTO TABLE WS
D.SELECT*FROM S WHERE性别=ˋ女ˊ0R年龄<=18 OREDER BYˋ年龄ˊASC INTO TABLE WS
参考答案:
答案解析: