Sql decode

DECODE(X, D1, R1, D2, R2, D3, R3, ..., Rx)
/*
if X = D1 then return R1
else if X = D2 then return R2
else if X = D3 then return R3
...
else return Rx
*/

Similar codes

0 vote262 views1 answer
Mariadb maximum left join
SQL
0 vote265 views1 answer
How to display value of variable in mysql
SQL
20 votes303 views4 answers
How to find average in sql
SQL
0 vote283 views1 answer
Sql max of two values
SQL
0 vote285 views1 answer
How to join result table in mysql
SQL
0 vote268 views1 answer
Template MySQL Zabbix agent
SQL
31 votes269 views4 answers
How to get duplicate records with multiple field in sql
SQL
12 votes268 views10 answers
Google
SQL
0 vote228 views1 answer
Print sum of values sql
SQL
0 vote260 views2 answers
Sql if empty then
SQL