Multiple choice

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

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

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

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

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

  5. All of the above

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

Yes, it is true.

Keep practicing — related questions