Question: 5. The tblBooks table in the Books database contains a numeric field named Price. Which of the following determines the number of books whose price
5. The tblBooks table in the Books database contains a numeric field named Price. Which of the following determines the number of books whose price is at least $20? The dataset’s name is BooksDataSet.
a. Dim intNum As Integer =
Aggregate book In BooksDataSet.tblBooks Where book.Price > 20 Into Count
b. Dim intNum As Integer =
Aggregate book In BooksDataSet.tblBooks Where book.Price >= 20 Into Sum
c. Dim intNum As Integer = Aggregate book In BooksDataSet.tblBooks Where book.Price >= 20 Select book
d. Dim intNum As Integer = Aggregate book In BooksDataSet.tblBooks Where book.Price >= 20 Into Count
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
