Question 17Asked in DSSSB TGT Computer Science (Technical), 12 Sep 2025, Shift 2 (1:00 PM)

SELECT MAX(result) FROM student WHERE result < (SELECT MAX(result) FROM

SELECT MAX(result) FROM student WHERE result < (SELECT MAX(result) FROM student);

ASELECT result FROM student WHERE ROWNUM = 2 ORDER BY result DESC;
BSELECT TOP 2 result FROM student ORDER BY result DESC;
CSELECT result FROM student ORDER BY result DESC LIMIT 1 OFFSET 1;
DSELECT MAX(result) FROM student WHERE result < (SELECT MAX(result) FROM student);

Show answerHide answer

Correct answer: (D) SELECT MAX(result) FROM student WHERE result < (SELECT MAX(result) FROM student);

Explanation

Note: the question statement is missing in the source paper; only the SQL query shown above and the options were printed. The official answer key marks option 4 (the same query as the one shown).

SELECT MAX(result) FROM student WHERE result < (SELECT MAX(result) FROM

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