使用Case语句作为透视- DB2

CASE 
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    ...
    ELSE result
END

SELECT column_name,
       CASE column_name
           WHEN value1 THEN 'Category 1'
           WHEN value2 THEN 'Category 2'
           ELSE 'Other'
       END AS category
FROM table_name;

SELECT column_name,
       CASE
           WHEN condition1 THEN 'Result 1'
           WHEN condition2 THEN 'Result 2'
           ELSE 'Other'
       END AS result
FROM table_name;