Consider the following SQL query, which is intended to find students who have marks higher than the student with ID = 10: SELECT Name FROM Student WHERE Marks > (SELECT Marks FROM Student WHERE ID = 10); What potential issue could occur with this query?

Crowdly

Add to Chrome

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Consider the following SQL query, which is intended to find students who have marks higher than the student with ID = 10:

<SQL>

SELECT
      Name

FROM
      Student

WHERE
      Marks > (SELECT Marks FROM Student WHERE ID = 10);

What potential issue could occur with this query?

It requires a GROUP BY clause

83%

The Marks column is invalid

The query is always correct

It fails if the subquery returns multiple rows

17%

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome