Using a conditional UPDATE statement in SQL
SqlSql ServerSql Problem Overview
I would like to have an UPDATE
statement like this:
SELECT *
FROM Employee
WHERE age = CASE
WHEN (age < 20) THEN age=15
WHEN (age > 20) THEN age= 20
Is this not possible in SQL Server / MySQL? I do not want to use the stored procedures or other things.
Suggest me a suitable way around this problem.
Sql Solutions
Solution 1 - Sql
I think what you want is:
UPDATE EMPLOYEE
SET age =
CASE WHEN AGE < 20 THEN 15
ELSE 20 END
Solution 2 - Sql
You can use a case statement in an update as follows...
UPDATE Employee
SET Age = CASE WHEN (age < 20) THEN 15
ELSE 20 END