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

Posted on by Tran Anh

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”
Xem thêm:

Bài viết cùng chủ đề:

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