Oracle
1Z0-082 · Question #41
Examine this SQL statement: 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 Identify…
The correct answer is A. ORDER BY "Last Name" B. ORDER BY 2, 1 C. ORDER BY 2, cust_id. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Examine this SQL statement:
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 Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)
Options
- AORDER BY "Last Name"
- BORDER BY 2, 1
- CORDER BY 2, cust_id
- DORDER BY CUST_NO
- EORDER BY "CUST_NO"
How the community answered
(25 responses)- A76% (19)
- D8% (2)
- E16% (4)
Topics
#UNION#ORDER BY#column aliases#set operators
Community Discussion
No community discussion yet for this question.