Sql case update

UPDATE dbo.TestStudents  
SET     LASTNAME =  CASE  
                        WHEN LASTNAME = 'AAA' THEN 'BBB' 
                        WHEN LASTNAME = 'CCC' THEN 'DDD' 
                        WHEN LASTNAME = 'EEE' THEN 'FFF' 
                        ELSE LASTNAME
                    END 
WHERE   LASTNAME IN ('AAA', 'CCC', 'EEE')

Source: stackoverflow.com

Similar codes

0 vote311 views1 answer
Postgresql select fast check no rows
SQL
0 vote308 views1 answer
Postgres 11 add primary key
SQL
0 vote344 views3 answers
Condition in count sql
SQL
0 vote319 views1 answer
Mysqldump ignore table
SQL
0 vote314 views1 answer
Rollback to name in sql
SQL
0 vote320 views1 answer
Formatting code with SQL Developer
SQL
5 votes363 views1 answer
Oracle drop index if exists
SQL
0 vote332 views1 answer
Oracle sql number to varchar2
SQL
0 vote329 views1 answer
Multiple like values for single column postgres
SQL
0 vote316 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL