Multiple choice

Write a query to display students details whose marks are greater than 80. Note: Choose the most appropriate answer from the given choices.

  1. SELECT * FROM STUDENTS WHERE MARKS > 80

  2. SELECT ALL FROM STUDENTS WHERE MARKS > 80

  3. SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > 80

  4. SELECT ALL STUDENT_ID FROM STUDENTS WHERE MARKS > 80

  5. All of the above

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

Yes, this is the correct syntax.

Keep practicing — related questions