what is wrong in this query select from orders where orderid..., PostgreSQL, Databases

Test
- Model Test
Index

Question:What is wrong in this query:
Select * from Orders where OrderID=(select OrderID from OrderItems where ItemQty>50)

A In a 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 be used first 
D None of these above

/85

+ AnswerB

+ Report

Descriptive on PostgreSQL Ebook

Total Preview: 676

Question:What is wrong in this query: Select * from Orders where OrderID=(select OrderID from OrderItems where ItemQty>50)

A In a 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 be used first

D None of these above

B