ocp题库解析：1Z0-051-V9.02-第156题
来源：优技教育
ocp题库解析：1Z0-051-V9.02-第156题，完整题库请点击这里联系老师咨询了解
156. 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"
Answer: ACE
试题解析：
ORDER BY 后面可以跟数字，可以完全一摸一样的列名,经过union后，字段名根据第一个查询语句显示，变为cust_id和Last Name。
精华阅读