题目内容

查询持有外币种类在4种以上人员的姓名，及持有的种类数量，并按种类数量升序排列，数量相同时，则按姓名降序排列，下列语句正确的是()。

A. SELECT 姓名,COUNT() AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT()＞=4; ORDER BY 外币种类,姓名 DESC
B. SELECT 姓名,COUNT() AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT()＞=4; ORDER BY COUNT(),姓名 DESC
C. SELECT 姓名,COUNT() AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT()＞=4; ORDER BY 外币种类 AND 姓名 DESC
D. SELECT 姓名,COUNT() AS 外币种类 FROM 持有数; GROUP BY 姓名 HAVING COUNT(*)＞=4; ORDER BY 外币种类+姓名 DESC

查看答案

搜索结果不匹配？点我反馈

更多问题

Which of the following titles best illustrate the idea of the passage？

A. Nutritious Food
B. Varieties of Cheese
C. A Concentrated Source of Nutrients
D. Cheese

查看答案

If you want to go on a diet, you can eat cheese because ______ .

A. it contains the highest amount of fat, cholesterol, and calories
B. it holds high protein and calcium content
C. it can be mixed with skim milk
D. growing bodies require higher amounts of protein

查看答案

In the first paragraph. "people have raised animals for milk, turning their surplus milk into cheese." -- "surplus" means ______ .

A. favorite
B. delicious
C. abundant
D. excess

查看答案

删除“持有数”表中所有外币名称为“法郎”的记录，下列SQL语句正确的是()。

A. DELETE FROM 持有数; WHERE 持有数.外币代码=外汇名.外币代码; AND 外币名称="法郎"
B. DELETE FROM 持有数,外汇名; WHERE 持有数.外币代码=外汇名.外币代码; AND 外币名称="法郎"
C. DELETE FROM 持有数 WHERE 外币代码 IN; (SELECT 外币代码 FROM 外汇名 WHERE 外币名称="法郎")
DELETE FROM 持有数 WHERE 外币代码 IN; SELECT 外币代码 FROM 外汇名 WHERE 外币名称="法郎"

查看答案