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

Posted on by Tran Anh

Q88 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