Question:Consider the following select statement and its output:
 
SELECT * FROM table1 ORDER BY column1; 

Column1
--------
1
2
2
2
2
2
3

Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2? 

A DELETE FIRST 4 FROM table1 WHERE column1=2 
B DELETE 4 FROM table1 WHERE column1=2 
C DELETE WHERE column1=2 LIMIT 4 
D DELETE FROM table1 WHERE column1=2 LIMIT 3 
E DELETE FROM table1 WHERE column1=2 LEAVING 1 

+ Answer
D 

+ 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