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 vote171 views1 answer
Mysql select smaller of two values
SQL
21 votes212 views3 answers
Average sql
SQL
0 vote179 views1 answer
Psql check table fields
SQL
0 vote171 views1 answer
Qt qsql check if table exist
SQL
0 vote172 views1 answer
Oracle merge insert if not exists
SQL
0 vote162 views1 answer
Mysql remove tabs from string
SQL
0 vote165 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote230 views3 answers
CONTACT FORM SQL
SQL
-1 vote157 views1 answer
Sql getdate date only
SQL
1 vote178 views1 answer
Mysql average of multiple columns
SQL