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 vote90 views1 answer
Postgres first_value in gropby
SQL
0 vote96 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote97 views1 answer
Oracle sql listagg
SQL
0 vote93 views1 answer
Show table structure mysql console
SQL
53 votes267 views6 answers
How to install mysql ubuntu
SQL
0 vote97 views1 answer
Contact mysql column field
SQL
1 vote113 views2 answers
Sql queries practice
SQL
0 vote89 views1 answer
Grepper sql workbench download
SQL
0 vote158 views1 answer
Insensitive case match sqlalchemy
SQL
8 votes107 views2 answers
Grant all privileges database postgres to user
SQL