现有书目表book，包含字段：price（float）；现在查询一条书价最高的书目的详细信息，以下语句正确的是（）
A.select top 1 * from book order by price asc
B.select top 1 * from book order by price desc
C.select top 1 * from book where price= (select max (price)from book)
D.select top 1 * from book where price= max(price)
参考答案：B, C
| 完形填空。 | ||||
| It was Molly's job to hand her father his paper lunch bag each morning before he went to work. One morning, besides his usual lunch bag, Molly 1 him a second paper bag. This one didn't look so good. It was 2 and was held together with tape (胶带). Her father kissed Molly and started off to work with the 3 bags. On his lunch break, while he was eating, he looked 4 the second old bag:two small dolls, three small stones and some coins. The busy father smiled, finished eating and 5 away the bags, dolls and stones. That 6 when they were having supper, Molly asked, "Where's my bag, Daddy?" "What bag?" "The one I gave 7 this morning." "I left it at the office. 8 ?" "I forgot to put this note in it," she said."Those are the 9 I really love. I thought you might like to 10 with them. You didn't lose the bag, did you,Daddy?" "Oh, no, "he said, lying (说谎). "I 11 forgot to bring it home. I'll bring it tomorrow." When Molly put her arms around her father's neck,he opened the 12 that read: "I love you, Daddy." Molly had given him her treasures (财富), 13 he had thrown them into the trash can (垃圾箱). So when he went back to the 14 , he went straight to the trash can and 15 all of Molly's things. He put the treasures inside the bag and carried it home. | ||||
|