what is wrong with the following query select from orders where..., SQL, Databases

Test
- Model Test
Index

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

A In the sub query, '*' should be used instead of 'OrderID' 
B The sub query can return more than one row, so, '=' should be replaced with 'in' 
C The sub query should not be in parenthesis 
D None of these above

/98

+ AnswerB

+ Report

Descriptive on SQL Ebook

Total Preview: 11130

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

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

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

C The sub query should not be in parenthesis

D None of these above

B