65.View the Exhibit and examine the structure of the CUSTOMERS table.

最新推荐文章于 2016-03-15 20:16:47 发布

原创最新推荐文章于 2016-03-15 20:16:47 发布 · 682 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#1z0-051

1z0-051 专栏收录该内容

175 篇文章

订阅专栏

本文介绍了一种使用SQL查询语句来实现对客户表中数据进行排序的方法，具体为按照城市和收入水平两个字段进行降序排列。通过示例展示了如何正确书写SQL ORDER BY子句以满足特定的数据展示需求。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

65.View the Exhibit and examine the structure of the CUSTOMERS table.
You have been asked to produce a report on the CUSTOMERS table showing the customers details
sorted in descending order of the city and in the descending order of their income level in each city.
Which query would accomplish this task?
A.SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_city desc, cust_income_level DESC ;
B.SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_income_level desc, cust_city DESC;
C.SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY (cust_city, cust_income_level) DESC;
D.SELECT cust_city, cust_income_level, cust_last_name
FROM customers
ORDER BY cust_city, cust_income_level DESC;
答案：A
解析：题目说city降序，income level降序,C语法错误