What result set will the following query return? Select Item_No, description
From item
Where weight > 100 and weight < 200;

Question

What result set will the following query return? Select Item_No, description
From item
Where weight > 100 and weight < 200;
A) The Item_No and description for all items weighing less than 100
B) The Item_No for all items weighing between 101 and 199
C) The Item_No and description for all items weighing between 101 and 199
D) The Item_No for all items weighing more than 200

Quizplus · Accepted Answer

The query is selecting the Item_No and description from the item table where the weight is between 100 and 200. Therefore, the result set will include the Item_No and description for all items weighing between 101 and 199.

What Result Set Will the Following Query Return? Select Item_No