SQL IF ELSE

Else if sql

UPDATE table 
SET columnB = CASE fieldA 
        WHEN columnA=1 THEN 'x' 
        WHEN columnA=2 THEN 'y' 
        ELSE 'z' 
      END 
WHERE columnC = 1

Source: stackoverflow.com

Similar codes

5 votes244 views2 answers
Postgres update with if condition query
SQL
0 vote230 views1 answer
Soql more than today
SQL
14 votes239 views3 answers
Sql trim from string
SQL
0 vote234 views1 answer
Get number of tables in database sql
SQL
4 votes239 views1 answer
Phone number sql
SQL
-1 vote216 views2 answers
Sql query examples
SQL
0 vote253 views1 answer
Postgres list users and roles
SQL
0 vote256 views1 answer
Oracle webcenter content search enginer
SQL
0 vote237 views1 answer
Oracle list of long running queries
SQL
0 vote253 views1 answer
Get clob size oracle
SQL