Which of the following statements can you use to delete all orders from the Orders table where the productID is 343 and the shipping country is India ?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 3875 | Points: 40
Select from following answers:
  1. DELETE FROM Orders WHERE productID = 343 AND shippingcountry = N'India'
  2. DELETE FROM Orders WHERE productID = 343 OR shippingcountry = N'India'
  3. DELETE FROM Orders WHERE productID = 343 AND NOT shippingcountry = N'India'
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response