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 

+ Answer
B 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description