oracle sql语句怎么实现列转行

发布网友发布时间：2022-04-28 23:52

共2个回答

热心网友时间：2022-04-08 03:37

我能想到的就是union了

select bz a,'BZ' b
from xy_bzrdbap
union
select fbz a,'FBZ' b
from xy_bzrdbap
union
select zzwy a,'ZZWY' b
from xy_bzrdbap
...

热心网友时间：2022-04-08 04:55

SELECT BZ AS A,'BZ' AS B
FROM xy_bzrdbap
WHERE bjid=362

UNION
SELECT FBZ AS A,'FBZ' AS B
FROM xy_bzrdbap
WHERE bjid=362
UNION
SELECT ZZWY AS A,'ZZWY' AS B
FROM xy_bzrdbap
WHERE bjid=362
...

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com