SQL实现分组查询的短语是______。A．ORDERBY B．GROUPBY C．_爱下问搜题

搜题请搜索小程序“爱下问搜题”

问题单项选择题

SQL实现分组查询的短语是______。

A．ORDERBY

B．GROUPBY

C．HAVING

D．ASC

答案

参考答案：B

解析：[知识点] 关系数据库标准语言SQL/SQL的数据查询功能[评析] 4个选项中所列出的短语都是SELECT语句的短语，其中C选项HAVING不能脱离GROUPBY短语而独立存在，D选项ASC不能脱离ORDERBY短语而独立存在。实现分组查询的短语是GROUPBY。A选项ORDER BY短语是对最终的查询结果进行排序；C选项HAVING短语是用于限定分组的条件；D选项ASC是限定按指定属性值的升序进行排序。若需要HAVING短语，HAVING短语必须出现在GROUP BY短语之后，若需要ASC(DESC.降序)短语，则必须出现在ORDERBY短语之后，通常GROUPBY短语出现在ORDER BY短语之前。

单项选择题 A3/A4型题

某男性工人，40岁，是某家具厂的油漆工，工龄约10年。近一段时间感觉头痛、头晕和失眠等症，易患感染并常伴有牙龈和皮下出血。

应采用何种治疗方法（）

A.解毒治疗

B.排毒治疗

C.病因治疗

D.对症治疗

E.支持治疗

完形填空

完形填空（共20小题：每小题1. 5分，满分30分）
In a land far away, once upon a time there was great poverty （贫困）,and only the rich could manage without great _26_. Three of those rich men and their servants were_27_together on a road when they came to a very_28_village.
The first could not stand seeing the poverty, _29 he took all the gold and jewels from his wagons (四轮载重马车) and shared _30 out among the villagers. He wished them all the best of luck, and he left.
The second rich man ,seeing the _31 situation, stopped for a short time and gave _32 all his food and drink, since he _33 see that money would be of little _34 to them. He made sure that they each _35   their fair share and would have enough food to _36   for some time. Then, he left.
The third rich man, on seeing such poverty, _37   and went straight through the _38 without stopping. The two other rich men saw this from a distance and commented（评论） with each other_39   the third rich man lacked sympathy（同情）. It was _40   that they themselves had been there to offer help.
However, three days later, they   41 the third rich man, who was coming in the opposite direction. He was 42 travelling quickly, but his wagons, 43 the gold and valuables they had been 44 ,were now full of farming tools and bags of 45 .He was rushing back to help them out of poverty.

B．expectations

A．the villagers

B．his servants

A．turned back