SELECT using CASE in SQL

Question

I have a set of one to one mappings A -  apple  B-  Banana and like that   My table has a column with values as A B C    Now I m trying to use a select statement which will give me the direct result   SELECT    CASE       WHEN FRUIT    A  THEN FRUIT   APPLE        ELSE WHEN FRUIT   B  THEN FRUIT   BANANA        FROM FRUIT TABLE    But I m not getting the correct result  please help me

User · Accepted Answer

This is just the syntax of the case statement, it looks like this.

SELECT 
  CASE 
    WHEN FRUIT = 'A' THEN 'APPLE' 
    WHEN FRUIT = 'B' THEN 'BANANA'     
  END AS FRUIT
FROM FRUIT_TABLE;

As a reminder remember; no assignment is performed the value becomes the column contents. (If you wanted to assign that to a variable you would put it before the CASE statement).

User · Answer

which platform    SELECT    CASE      WHEN FRUIT    A  THEN  APPLE       ELSE FRUIT   B  THEN  BANANA      END AS FRUIT      FROM FRUIT TABLE

User · Answer

Try this   SELECT    CASE       WHEN FRUIT    A  THEN  APPLE       WHEN FRUIT    B  THEN  BANANA       ELSE  UNKNOWN FRUIT    END AS FRUIT FROM FRUIT TABLE

User · Answer

Change to   SELECT    CASE      WHEN FRUIT    A  THEN  APPLE       WHEN FRUIT    B  THEN  BANANA         END FROM FRUIT TABLE

[sql] SELECT using 'CASE' in SQL

Examples related to sql

Examples related to select

Examples related to case