Based on the code above,delete any row in the OrderLine table in which the item number is MT03.
A) DELETE FROM OrderLine WHERE ItemNum='MT03' ;
B) DELETE FROM OrderLine WHERE ItemNum=MT03;
C) DELETE FROM OrderLine WHERE ItemNum='MT03'
D) DELETE FROM OrderLine WHERE ItemNum='MT3' ;

Question

Based on the code above,delete any row in the OrderLine table in which the item number is MT03.​
A) ​DELETE FROM OrderLine WHERE ItemNum='MT03' ;
B) ​DELETE FROM OrderLine WHERE ItemNum=MT03;
C) ​DELETE FROM OrderLine WHERE ItemNum='MT03'
D) ​DELETE FROM OrderLine WHERE ItemNum='MT3' ;

Quizplus · Accepted Answer

The correct SQL syntax for deleting rows where the ItemNum is 'MT03' includes using single quotes around the string value 'MT03'.

Based on the Code Above,delete Any Row in the OrderLine