What result set will the following query return?
Select item_no
From order_v
Where quantity 10;
A) The item_no of all orders that had more than 10 items
B) The order_id of all orders that had more than one item
C) The order_id of all orders that had more than 10 items
D) The item_no of all orders that had 10 or more items

Question

What result set will the following query return?
Select item_no
From order_v
Where quantity > 10;
A) The item_no of all orders that had more than 10 items
B) The order_id of all orders that had more than one item
C) The order_id of all orders that had more than 10 items
D) The item_no of all orders that had 10 or more items

Quizplus · Accepted Answer

The query selects item_no from order_v where the quantity is greater than 10, which matches option A.

What Result Set Will the Following Query Return