The tblItems table contains a numeric field named Price.Which of the following statements finds the lowest price for an item and assigns the result to the dblLowPrice variable?
A)Dim dblLowPrice As Double =Min item In Items.DataSet.tblItemsSelect item.Price
B)Dim dblLowPrice As Double =Aggregate item In Items.DataSet.tblItemsSelect item.Price Into Min()
C)Dim dblLowPrice As Double =Select Min item In Items.DataSet.tblItems
D)Dim dblLowPrice As Double =Select Aggregate item In Items.DataSet.tblItemsInto Min()

Question

Quizplus · Accepted Answer

Option B uses the Aggregate function with the Min function to find the lowest price in the tblItems table and assign it to the dblLowPrice variable. Option A is not a valid syntax for finding the minimum value. Option C and D contain syntax errors.

The TblItems Table Contains a Numeric Field Named Price