问题 填空题

在SQL分组与计算查询中,利用______短语可以对分组条件进一步加以限定。

答案

参考答案:HAVING

解析: 在实际的应用中,除了简单的计算查询外,我们还可以加上GROUP BY子句进行分组计算查询。 通常来说,一个计算函数的范围是满足WHERE子句指定条件的所有记录。当加上GROUP BY子句后,系统会将查询结果按指定列分成集合组。当一个计算函数和一个GROUP BY子句一起使用时,计算函数的范围变为每组所有的记录。也就是说,一个结果是由组成一组的每个记录集合产生的。 另外,使用HAVING子句可以对这些组进一步加以控制。用这个子句定义这些组所必须满足的条件,以便将其包含在结果中。

解答题
阅读理解

For those who long ago lost interest in the annual CCTV Spring Festival Gala, some new online offerings might be pleasant alternative. They started appearing 2002 and could have a phenomental (非凡的)presence this year.

The online versions keep the essence of the CCTV one, but replace the less popular parts. To draw viewers, there is no shortage of big name stars. Some A-list performers, including singers XuWei, SunNan and crosstalk performers, can be found here. The interesting part, however, is the host of the celebrities who have risen to fame online, from Xidan Metro Girl (西单女孩)to Sister Lotus (芙蓉姐姐), for example. The anchors are the Back Dormitory Boys(后舍男生), a Chinese group who gained fame for lip-synch(假唱) songs by the Backstreet Boys and other pop stars.

What’s more significant is that it’s unprecedented in its interactivity.

“In online Spring Festival galas, I can vote for an earlier broadcast of programs that I like,” said Yu Ting, 23, a Peking University student. “I can also just click for my applause, and can even throw “tomatoes” or “rotten eggs” at those acts I really don’t like. I’m like the master of ceremonies or virtual producer of my own gala.”

Obviously, this has put an extra burden on the performers, who have to worry about being dropped by the audience at any time. However, it means original fun for netizens who like to “direct” their own entertaining bits.

No matter what you taste, the online Spring Festival galas offer multiple choices for the holiday. Everyone gets to enjoy whatever he or she likes.

64.What is the meaning of the underlined word?

A. the worst parts  B. the best parts  C. the less popular parts   D. the original parts

65.what is true about the Back Dormitory Boys?

A. It’s a pop group good at crosstalk.

B. It’s a pop group made up of six handsome boys.

C. They often sing songs by the Westlife.

D. they sing their songs in a special way.

66.From the passage, we can learn about the online Spring Festival Galas that            .

A. They started appearing in 1983.

B. People often take tomatoes and rotten eggs with them when watching

C. People can’t give their support in any way.

D. People enjoy the feeling of being the master of the galas.

67. You can find the passage in a _____________.

A. newspaper   B. guidebook   C. storybook   D. catalog