职员.DBF：职员号 C(3)，姓名 C(6)，性别 C(2)，组号 N(1)，职务_爱下问搜题

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

问题单项选择题

职员.DBF：职员号 C(3)，姓名 C(6)，性别 C(2)，组号 N(1)，职务 C (10) 客户.DBF：客户号 C(4)，客户名 C(36)，地址 C(36)，所在城市 C (36) 订单.DBF：订单号 C(4)，客户号 C(4)，职员号 C(3)，签订日期 D，金额 N(6,2) 查询金额最大的那 10%订单的信息。正确的 SQL 语句是______。

A．SELECT * TOP 10 PERCENT FROM 订单

B．SELECT TOP 10% * FROM 订单 ORDER BY 金额

C．SELECT * TOP 10 PERCENT FROM 订单 ORDER BY 金额

D．SELECT TOP 10 PERCENT * FROM 订单 ORDER BY 金额 DESC

答案

参考答案：D

解析：Visual FoxPro的SELECT－SQL命令的一般语法格式如下：SELECT [ALL|DISTINCT]<目标列表达式>[,<目标列表达式>]…FROM<基本表(或视图)> [,<基本表(或视图)>]…[WHERE<条件表达式>][GROUP BY<列名1>[HAVING<内部函数表达式>]][ORDER BY<列名2>[ASC|DESC]][TOP<数值表达式>[PERCENT]]说明：①ORDER BY子句：指定查询结果中记录按<列名2>排序，默认升序。选项ASC表示升序，DESC表示降序。② TOP子句：TOP子句必须与ORDER BY子句同时使用。<数值表达式>表示在符合条件的记录中选取的记录数。范围1~32 767，排序后的若干记录只计一个。含PERCENT选项时，<数值表达式>表示百分比，记录数为小数时自动取整，范围0.01~99.99。

完形填空

In a land far away, once upon a time there was great poverty （贫困）,and only the rich could manage without great _36. Three of those rich men and their servants were_37_together on a road when they came to a very_38_village.
The first could not stand seeing the poverty, _39 he took all the gold and jewels from his wagons (四轮载重马车) and shared 40 out among the villagers. He wished them all the best of luck, and he left.
The second rich man ,seeing the _41 situation, stopped for a short time and gave _42 all his food and drink, since he _43 see that money would be of little _44 to them. He made sure that they each 45their fair share and would have enough food to _46 for some time . Then, he left.
The third rich man, on seeing such poverty, _47 and went straight through the _48 without stopping. The two other rich men saw this from a distance and commented with each other 49 the third rich man lacked sympathy. It was _50 that they themselves had been there to offer help.
However, three days later, they 51the third rich man ,who was coming in the opposite direction . He was 52 travelling quickly, but his wagons, 53 the gold and valuables they had been 54 ,were now full of farming tools and bags of 55 .He was rushing back to help them out of poverty.

B．expectations

A．the villagers

B．his servants

A．turned back

单项选择题

根据4.3.3目标指标和方案要求以下哪个（）说法是错误的？

A.应针对相关职能和层次建立、实施并保持形成文件的环境目标和指标

B.目标和指标应可测量

C.目标和指标应符合环境方针，包括对污染预防、持续改进和遵守法律法规和其他要求

的承诺

D.应考虑法律法规和其他要求，以及自身的环境因素