Which query would give you the desired output?

View the Exhibit and examine the structure of the ORDERS table. You have to display
ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed
after the last order placed by the customer whose CUSTOMER_ID is 101 Which query
would give you the desired output?

View the Exhibit and examine the structure of the ORDERS table. You have to display
ORDER_ID, ORDER_DATE, and CUSTOMER_ID for all those orders that were placed
after the last order placed by the customer whose CUSTOMER_ID is 101 Which query
would give you the desired output?

A.
SELECT order id, order_date FROM orders WHERE order_date > ALL (SELECT
MAX(order_date) FROM orders) AND Customer_id = 101;

B.
SELECT order id, order_date FROM orders WHERE order_date > ANY (SELECT
order_date FROM orders WHERE customer_id = 101);

C.
SELECT order _id, order_date FROM orders WHERE order_date > ALL (SELECT
order_date FROM orders WHERE customer_id = 101);

D.
SELECT order id, order_date FROM orders WHERE order_date IN (SELECT order_date
FROM orders WHERE customer id = 101);



Leave a Reply 0

Your email address will not be published. Required fields are marked *