Multiple choice

Write a query to choose all the students who have got the least marks in the exam.

  1. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MIN(MARKS)

  2. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS = ( SELECT MIN(MARKS) FROM STUDENTS )

  3. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS = MIN(MARKS)

  4. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS = MIN

  5. All of the above are correct.

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Yes, it is true.