Solved

Consider the Following SQL Query

Question 12

Multiple Choice

Consider the following SQL query.Which item best describes the results of the query?SELECT VendorID,Sum(POTotal) FROM [Purchase Orders]GROUP BY VendorID


A) Displays all purchase order lines for all vendors.
B) Adds new purchase order information to the purchase orders table.
C) Displays the vendor ID and all purchase order totals in the purchase orders table.
D) Displays the vendor ID and the sum of all purchase order totals for that vendor.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions