-- 创建测试表格
CREATE TABLE test_table (
id NUMBER,
category VARCHAR2(10),
value NUMBER
);
-- 向测试表格插入数据
INSERT INTO test_table VALUES (1, 'A', 10);
INSERT INTO test_table VALUES (1, 'B', 20);
INSERT INTO test_table VALUES (1, 'C', 30);
INSERT INTO test_table VALUES (2, 'A', 40);
INSERT INTO test_table VALUES (2, 'B', 50);
INSERT INTO test_table VALUES (2, 'C', 60);
COMMIT;
-- 使用PIVOT进行行转列
SELECT * FROM (
SELECT id, category, value
FROM test_table
) PIVOT (
MAX(value) FOR category IN ('A' AS A, 'B' AS B, 'C' AS C)
);
Oracle 行转列
最新推荐文章于 2024-07-25 08:41:32 发布