Q150 Identify three ORDER BY clauses, any one of which can complete the query successfully

Q150 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.)

  • A) ORDER BY “Last Name”
  • B) ORDER BY 2, 1
  • C) ORDER BY 2, cust_id
  • D) ORDER BY CUST_NO
  • E) ORDER BY “CUST_NO”
0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận