Which of the following will produce the minimum of all standard prices?
A) Select standard_price from product_v where standard_price = min;
B) Select min(standard_price) from product_v;
C) Select standard_price from min(product_v);
D) Select min(standard_price) from product_v where standard_price = min(standard_price);

Question

Quizplus · Accepted Answer

Option B uses the aggregate function MIN() to directly retrieve the minimum value of the standard_price column from the product_v table. This produces the minimum of all the standard prices. Option A attempts to compare the standard_price column to the minimum value, which may not give the intended result. Option C is invalid SQL syntax and would result in a syntax error. Option D uses the WHERE clause to compare the standard price to the minimum value, but this is unnecessary because we can simply use the MIN() aggregate function to retrieve the minimum value directly.

Which of the Following Will Produce the Minimum of All