> > >

MySQL MCQs

What is wrong with the following query:
select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

In the sub query, '*' should be used instead of 'OrderID'

The sub query can return more than one row, so, '=' should be replaced with 'in'

The sub query should not be in parenthesis

None of the above

Answer

Correct Answer: The sub query can return more than one row, so, '=' should be replaced with 'in'

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it