一、原题
二、题目翻译
三、题目解析
Evaluate the following SQL statement:
SQL>SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30;
Which ORDER BY clauses are valid for the above query? (Choose all that apply.)
A. ORDER BY 2,1
B. ORDER BY CUST_NO
C. ORDER BY 2,cust_id
D. ORDER BY "CUST_NO"
E. ORDER BY "Last Name"
答案:ACE
SQL>SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30;
Which ORDER BY clauses are valid for the above query? (Choose all that apply.)
A. ORDER BY 2,1
B. ORDER BY CUST_NO
C. ORDER BY 2,cust_id
D. ORDER BY "CUST_NO"
E. ORDER BY "Last Name"
答案:ACE
二、题目翻译
评估下面的语句:
哪一个ORDER BY子句是有效的(选择所有正确的选项)?
哪一个ORDER BY子句是有效的(选择所有正确的选项)?
三、题目解析
ORDER BY后可以使用数字表示select语句后的第几个字段,也可以使用列名。
B和D选项不正确,因为只能使用第一个查询的列进行排序,包括别名、列名或表达式。
B和D选项不正确,因为只能使用第一个查询的列进行排序,包括别名、列名或表达式。