Question discussion

Which of the following SQL statements will retrieve the lowest value from a column named 'Price' in a table named 'Products'?

359012Medium DSSSB TGT Computer Science 0 replies 0 views
0
Which of the following SQL statements will retrieve the lowest value from a column named 'Price' in a table named 'Products'?
  • ASELECT MIN(Price) FROM Products;
  • BSELECT LOWEST(Price) FROM Products;
  • CSELECT TOP 1 Price FROM Products ORDER BY Price ASC;
  • DSELECT Price FROM Products WHERE Price = MIN(Price);
Correct answer: A

Explanation

MIN(Price) returns the lowest value of the column. Other options use invalid functions or place an aggregate in WHERE.

Discussion 0

Nobody has replied yet. Start the discussion!