Sql if else in select

-- In a query (DUAL is for Oracle)
SELECT CASE lower(my_col)
	WHEN 'agree' THEN 'Ok' 
	WHEN 'maybe' THEN 'Wait' 
    ELSE 'Ko' 
END AS my_result
FROM DUAL;

Similar codes

2 votes181 views1 answer
Get first n letter of department name in sql
SQL
0 vote188 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote178 views1 answer
Postgress append string in select
SQL
0 vote188 views1 answer
Sql commands in android
SQL
10 votes132 views2 answers
Django mysql
SQL
0 vote196 views1 answer
Ajouter une clé etrangere mysql
SQL
9 votes176 views3 answers
Where in sql
SQL
1 vote187 views1 answer
Ubuntu access database from terminal
SQL
0 vote200 views1 answer
Virtuoso sql query tutorial
SQL
2 votes232 views3 answers
Mysql unix timestamp to date
SQL