The tblInventory table contains a numeric field named InStock. Which of the following statements selects all records

Question:

The tblInventory table contains a numeric field named InStock. Which of the following statements selects all records having at least 500 of the item in stock?

a. Dim records =

From item In InventoryDataSet.tblInventory

Where item >= 500

Select item.InStock

b. Dim records =

From item In InventoryDataSet.tblInventory

Select item.InStock >= 500

c. Dim records =

From item In InventoryDataSet.tblInventory

Where item.InStock >= 500

Select item

d. Dim records =

Select item.InStock >= 500

From tblInventory

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: