Multiple choice

SELECT STUDENT_ID, MARKS FROM STUDENTS WHERE MARKS > 80

What will be the output of the above query?

  1. There is a syntax error in this query.

  2. Only one row will be returned irrespective of the data.

  3. It always returns zero rows.

  4. It returns n number of rows, where n is the number of students whose marks are greater than 80.

  5. It returns all the rows in the table.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Yes, it is true. n varies with the data in the table.

Keep practicing — related questions