问题 单项选择题

18~25题所用的数据如表1和表2所示。
表1 员工表(RGB.dbf)
员工号姓名性别籍贯年龄工资/元
0001王吉兵江苏222003.50
0002张晓春安徽212100.50
0003左燕江苏232330.00
0004赵华安徽222800.00
0005李宁山东202600.00
表2 销售表(SSB.dbf)
员工号商品号金额/元
00010001981
00020002763
00010002802
00020003696
00030001755
00030003684
00040001891
00050001768
00040002656
00030002907
00010003800

要求出员工中总销售额前3名的员工的员工号、姓名和总销售额,下列语句中正确的是______。

A.SELECT TOP 3 员工号,姓名,总销售额; FROM RGB,SSB ORDER BY 总销售额

B.SELECT TOP 3 RGB.员工号,RGB.姓名,SUM(SSB.金额) AS 总销售额; FROM RGB INNER JOIN SSB; WHERE RGB.员工号=SSB.员工号; GROUP BY SSB.员工号; ORDER BY 3 DESC

C.SELECT TOP 3 RGB.员工号,RGB.姓名,SUM(SSB.金额) AS 总销售额; FROM RGB INNER JOIN SSB; ON RGB.员工号=SSB.员工号; GROUP BY SSB.员工号; ORDER BY 3 DESC

D.SELECT TOP 3 PERCENT RGB.员工号,RGB.姓名,; SUM(SSB.金额) AS 总销售额; FROM RGB INNER JOIN SSB; ON RGB.员工号=SSB.员工号; GROUP BY SSB.员工号; ORDER BY 3 DESC

答案

参考答案:C

解析:

[分析]: 本题涉及两个表,可对两个表按照“员工号”进行内部连接。为求出每个员工的总销售额,可按照员工号进行分组,对“金额”字段进行分组求和。为得出“总销售额”前三名的信息,可对查询结果按“总销售额”降序排列,用TOP 3关键词得到排在前面的3个员工的信息。

阅读理解

阅读理解。

     There's a man in the habit of hitting me on the head with an umbrella. At first I couldn't stand it, now I'm

used to it. 

      I don't know his name. I know he's average in appearance, wears a gray suit, and has a common face. I

met him five years ago one hot morning when I was sitting on a tree-shaded bench in Palermo Park, reading

the paper. Suddenly I felt something touch my head. It was the very same man who now, as I'm writing,

keeps hitting me, mechanically (机械地) and impassively, with an umbrella. 

     On that occasion I turned around filled with anger. He just kept on hitting me. I asked him if he was crazy,

he didn't even seem to hear me. Then I threatened to call a policeman. Calmly, cool as a cucumber, he stuck

with his task. After a few moments of hesitation, and seeing that he was not about to change his attitude, I

stood up and hit him on the nose. The man fell down, but he immediately got back on his feet, obviously with

great effort, and without a word again began hitting me on the head with the umbrella. His nose was bleeding

and, at that moment, I felt sorry for him. I felt regret for having hit him so hard. After all, the man wasn't

exactly hitting me; he was merely tapping me lightly with his umbrella, not causing any pain at all. Of course,

those taps were extremely bothersome. As we all know, when a fly lands on your forehead, you don't feel any

pain; what you feel is annoyance. Well then, that umbrella was one huge fly that kept landing on my head time

after time. 

     Convinced that I was dealing with a madman, I tried to escape. But the man followed me, wordlessly

continuing to hit me. So I began to run (I should point out that not many people run as fast as I do). He took

off after me, trying to land a blow. The man was out of breath so that I thought, if I continued to force him

to run at that speed, he would drop dead right then and there.

1. When the man began to strike the author with an umbrella, the author ______.[ ]

A. became angry

B. called the police

C. turned around and escaped

D. turned around and fought back

2. The author would most probably agree that the man was ______.

[ ]

A. deaf

B. blind

C. dead

D. mad

3. The author felt sorry for the man because ______. [ ]

A. the man formed a bad habit of beating others

B. he hit the man so hard that his nose bled

C. the man couldn't catch up with him

D. there was a fly on the man's head

4. It can be learned from the passage that the man ______. [ ]

A. shouted loudly while hitting the author

B. wanted to tell the author something

C. ran after the author breathlessly

D. acted as if he were a fly

填空题 案例分析题