怎么把一个表的字段
日期 X1 X2 X3 X4 X5
201611 1 3 2 5 6
转成
201611 "X1" 1
201611 "X2" 3
201611 "X3" 2
201611 "X4" 5
201611 "X5" 6
SQL脚本:
SELECT
DateKey,
ColumnA AS Type,
Case ColumnA WHEN 'X1' THEN X1
WHEN 'X2' THEN X2
WHEN 'X3' THEN X3
END AS Value
FROM test1, test2
ORDER BY DateKey, Type
原始数据截图:
结果数据截图: