--行列转换
SELECT * FROM it_suremainproblems WHERE mainapplyno='ITWX201409230092'
SELECT
a.mainapplyno,
wm_concat (a.proname) new_result
FROM
it_suremainproblems a WHERE mainapplyno='ITWX201409230092'
group by
a.mainapplyno
--end
--多行转一行
SELECT desktop_id , wm_concat(rp) AS rp ,wm_concat(zb) AS zb, wm_concat(cpus) AS cpus,wm_concat(nc) AS nc
FROM v_itparts WHERE desktop_id ='MSX-IT-1667' GROUP BY desktop_id
--end
SELECT * FROM it_suremainproblems WHERE mainapplyno='ITWX201409230092'
SELECT
a.mainapplyno,
wm_concat (a.proname) new_result
FROM
it_suremainproblems a WHERE mainapplyno='ITWX201409230092'
group by
a.mainapplyno
--end
--多行转一行
SELECT desktop_id , wm_concat(rp) AS rp ,wm_concat(zb) AS zb, wm_concat(cpus) AS cpus,wm_concat(nc) AS nc
FROM v_itparts WHERE desktop_id ='MSX-IT-1667' GROUP BY desktop_id
--end
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26495863/viewspace-1349812/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 批量更新&&批量插入用法
请登录后发表评论
登录
全部评论
