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

1 vote204 views2 answers
Oracle leftmost characters
SQL
2 votes193 views4 answers
Sql query interview questions
SQL
0 vote188 views2 answers
Mysql get routine parameter list
SQL
0 vote211 views1 answer
How to add unique key constraint in mysql
SQL
2 votes180 views1 answer
Sqlite show table indexes
SQL
1 vote171 views1 answer
Postgresql export output table as a csv
SQL
12 votes176 views4 answers
Mysql get date difference in hours
SQL
1 vote180 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote267 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote180 views1 answer
How to reset AI in sql
SQL