设有学生表S(学号,姓名,性别,年龄),查询所有年龄小于等于18岁的女同学、并按年龄进行降序排序生成新的表WS,正确的SQL命令是【 】。
A．SELECT*FROM sWHERE 性别=′女′AND年龄<=18ORDER BY 4DESC INTO TABLE WS
B．SELECT * FROM SWHERE性别=′女′AND年龄<=18ORDER BY年龄INTO TABLE WS
C．SELECT * FROM SWHERE性别=′女′AND年龄<=18 ORDER BY ′年龄′DESC INTO TABLE WS
D．SELECT * FROM SWHERE性别=′女′OR年龄<=1 8 ORDER BY′年龄′ASC INTO TARLE WS
参考答案：A
解析：按年龄的降序排列,所以要用短语DESC,排序的字段有两种表示方式,分别是按列号和字段名排序,因为字段名是变量,固不能加引号。
Good morning, ladies and gentlemen. I’ll give you a quick introduction to the school before I you around. Our school is called a “free school”. This means that pupils are free to choose what and how they want to learn. The school opens at 9 am, the children can arrive a little late if they like. Most of them are in school by ten. eight and nine most are in the living room and the kitchen downstairs. This is also a time children and teachers can work out what they are to do for the day. Now if you look the door of that big room, you will see those children busy doing something there. Several children are in the kitchen Miss Cabell with lunch. The children take to do this. After lunch it’s someone else’s job to do the washing-up. This job isn’t and not many of them like to do it. After lunch the children go on with what they’ve been doing school is over. On Friday we sometimes take the children to a cinema or a museum. The school is also every weekend for those children who want to come.
|