Question: 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
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
3.38 Rating (157 Votes )
There are 3 Steps involved in it
d Dim intNum As In... View full answer
Get step-by-step solutions from verified subject matter experts
