Multiple choice

Write a query to display students details whose marks are greater than the student whose STUDENT_ID is 123.

  1. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > 123

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

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

  4. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > ( SELECT MARKS FROM STUDENTS WHERE STUDENT_ID = 123 )

  5. All of the above

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

Yes, it returns the desired result.

Keep practicing — related questions