Which of the following SQL statements will retrieve the lowest value from a column named
Which of the following SQL statements will retrieve the lowest value from a column named
'Price' in a table named 'Products'?
Show answerHide answer
Correct answer: (A) SELECT MIN(Price) FROM Products;
Explanation
The aggregate function MIN() returns the smallest value in a column. LOWEST() does not exist, and an aggregate cannot be used directly in a WHERE clause.