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 votes113 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote81 views1 answer
Oracle sql replace string in clob
SQL
0 vote144 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
-2 votes125 views1 answer
No module named '_sqlite3
SQL
6 votes140 views2 answers
Clear a table in mysql
SQL
2 votes78 views5 answers
Alter table primary key postgresql
SQL
3 votes116 views2 answers
Sql server current date without time
SQL
0 vote140 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote140 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote124 views1 answer
Como hacer una consulta en sql
SQL