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

5 votes130 views1 answer
How to get all dates in a month in oracle
SQL
0 vote121 views1 answer
Sql new line output
SQL
0 vote102 views1 answer
Postgres create database if not exists
SQL
5 votes138 views1 answer
Sql integer to serial
SQL
0 vote143 views1 answer
How to find top 3 salary in sql
SQL
2 votes131 views2 answers
Useradd postgres
SQL
1 vote207 views1 answer
Adding a check statement in sql
SQL
0 vote145 views2 answers
Replace null with 0 in sql
SQL
0 vote154 views1 answer
How to fetch data from database in sql
SQL
1 vote155 views1 answer
Encrypt password postgresql
SQL