Which of the following statements returns order smaller than the largest order f

Question

Which of the following statements returns order smaller than the largest order for Customer 1199? SELECT CustomerName, OrderNumber, OrderTotal FROM Customers JOIN Orders ON Customers.CustomerlD = Orders.CustomerlD WHERE OrderTotal > ANY (SELECT OrderTotal FROM Orders WHERE CustomerlD = 1199) SELECT CustomerName, OrderNumber, OrderTotal FROM Customers JOIN Orders ON Customers.CustomerlD = Orders.CustomerlD WHERE OrderTotal > NONE (SELECT OrderTotal FROM Orders WHERE CustomerlD = 1199) SELECT CustomerName, OrderNumber, OrderTotal FROM Customers JOIN Orders ON Customers.CustomerlD = Orders.CustomerlD WHERE OrderTotal

Explanation / Answer

Answer :

Which of the following statements returns orders smaller than the largest order for customer 1199

Answer :

D

SELECT CustomerName,OrderNumber,OrderTotal From Customers JOIN ORDERS ON Customers.CustomerID=Orders.CustomerID

WHERE Orderotal < ALL (SELECT OrderTotal FROM Orders WHERE CustomerID=1199)

..............

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.