db2不能用unpivot

是的，DB2不支持UNPIVOT操作。相反，您可以使用表连接或CASE表达式来实现类似的功能。例如，假设您有一个包含以下数据的表：

| ID | Name | Score1 | Score2 | Score3 |
|----|------|--------|--------|--------|
| 1  | John | 85     | 90     | 95     |
| 2  | Jane | 75     | 80     | 85     |

要将每个分数转换为行，请使用以下查询：

SELECT ID, Name, 'Score1' AS ScoreType, Score1 AS ScoreValue
FROM your_table
UNION ALL
SELECT ID, Name, 'Score2' AS ScoreType, Score2 AS ScoreValue
FROM your_table
UNION ALL
SELECT ID, Name, 'Score3' AS ScoreType, Score3 AS ScoreValue
FROM your_table

这将返回以下结果：

| ID | Name | ScoreType | ScoreValue |
|----|------|-----------|------------|
| 1  | John | Score1    | 85         |
| 1  | John | Score2    | 90         |
| 1  | John | Score3    | 95         |
| 2  | Jane | Score1    | 75         |
| 2  | Jane | Score2    | 80         |
| 2  | Jane | Score3    | 85         |