Using a conditional UPDATE statement in SQL February 27, 2023 by Tarik I think what you want is: UPDATE EMPLOYEE SET age = CASE WHEN AGE < 20 THEN 15 ELSE 20 END