I believe you know the general way to write update statements. But let's revise and take a look at Figure 1.
If we want to update salary of the persons with salary over $50000, the query will look like this:
UPDATE Persons
SET salary = salary*2
WHERE salary > 50000;We have just doubled salary for these persons!
Let's see a more interesting example. Suppose we want to increase salary for persons with salary over $60000 by 3 percent, whereas all others receive a 5% raise. We want to do that by executing only one(!) query.
Try to write the query by yourself before you look at the solution.
We can do it using case statement:
