Answers for "sql if else if in select"

SQL
0

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;
Posted by: Guest on July-04-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language