SQL if/else statement

SQL has an IF/ELSE statement that allows you to do something if a condition is true, and something else if it’s not.

Here’s how it works:

IF condition THEN
statement1
ELSE
statement2
END IF;

For example, let’s say we have a table of employees, and we want to give a 10% raise to those who have been with the company for more than 5 years, and a 5% raise to everyone else. We could use the following SQL:

UPDATE employees SET salary = salary * 1.1 WHERE years_employed > 5;
UPDATE employees SET salary = salary * 1.05 WHERE years_employed <= 5;