Question 8Asked in DSSSB TGT Computer Science (Technical), 12 Sep 2025, Shift 3 (5:00 PM)

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'?
  1. ASELECT MIN(Price) FROM Products;
  2. BSELECT LOWEST(Price) FROM Products;
  3. CSELECT TOP 1 Price FROM Products ORDER BY Price ASC;
  4. DSELECT Price FROM Products WHERE Price = MIN(Price);
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.

From DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 3 (5:00 PM)

This is question 8 of DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 3 (5:00 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.