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

0 vote269 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
-1 vote357 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote289 views1 answer
Rename constraint postgresql
SQL
22 votes273 views4 answers
Show list of users in mysql
SQL
7 votes272 views1 answer
Minecraft forge server host
SQL
3 votes283 views1 answer
Oracle show trigger code
SQL
3 votes325 views1 answer
Mysql group_concat distinct
SQL
0 vote280 views1 answer
Mysql workbench view
SQL
0 vote289 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
9 votes314 views3 answers
Sql delete where in
SQL