Which one is the correct SQL statement to find the second highest mark from the STUDENT database that contains the marks of all students?

Which one is the correct SQL statement to find the second highest mark from the STUDENT database that contains the marks of all students?

  1. a) Select MAX(marks) from STUDENT WHERE marks NOT IN (select MAX(marks) from STUDENT)
  2. b) Select MAX(marks) from STUDENT WHERE marks IN (select MAX(marks) from STUDENT)
  3. c) select MAX(marks) from STUDENT
  4. d) select MAX(marks) from STUDENT WHERE marks NOT IN (select MIN(marks) from STUDENT)

From the Combined Bank Senior Officer October 2021 – Preliminary exam, question 35 of 108.

More from this paper