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 selects item numbers and descriptions from the table "item" where the weight is greater than 100 and less than 200, so the result set will consist of the item numbers and corresponding descriptions for all items with weights between 101 and 199.

What Result Set Will the Following Query Return