You run the following query against a table in the temp database:

SELECT *
FROM Sales
WHERE orderid = 3802;

You get the output shown in the exhibit.

The discount on the product with unitid 1 is 12.5%. You want to update this table so that you increase the discount assigned to each item in this order by an additional 5%.

Which of the following Transact-SQL statements can you use to accomplish this goal ?

 Posted by Rajkatie on 6/30/2013 | Category: Sql Server Interview questions | Views: 3879 | Points: 40
Select from following answers:
  1. UPDATE Sales SET discount += 0.05 WHERE orderid = 3802
  2. UPDATE Sales SET discount = 0.05 WHERE orderid = 3802
  3. UPDATE Sales SET discount *= 0.05 WHERE orderid = 3802
  4. All Above

Show Correct Answer


Source: measureup.com | | Alert Moderator 

Comments or Responses

Login to post response