求将横表转为竖表的SQL语句如图：

2025-02-25 15:06:04

推荐回答（3个）

回答1：

select stuno,stuname,marks1 from TB_test
union all select stuno,stuname,marks2 as marks1 from TB_test
union all select stuno,stuname,marks3 as marks1 from TB_test
union all select stuno,stuname,marks4 as marks1 from TB_test

回答2：

select STUNO,STUNAME,Marks1 from test2
union
select STUNO,STUNAME,Marks2 from test2
union
select STUNO,STUNAME,Marks3 from test2
union
select STUNO,STUNAME,Marks4 from test2

回答3：

oracle 11g和 SQL2005里似乎都有 pivot和unpivot函数。

看看是不是可以转换

求将横表转为竖表的SQL语句 如图：

求将横表转为竖表的SQL语句如图：