SyntaxFix
Write A Post
Hire A Developer
Questions
Try this.
SELECT CASE WHEN FRUIT = 'A' THEN 'APPLE' WHEN FRUIT = 'B' THEN 'BANANA' ELSE 'UNKNOWN FRUIT' END AS FRUIT FROM FRUIT_TABLE;