Oracle在存储过程中使用pivot函数实现列转行
这个表是关联查询出来的结果,sql为
select
GG_HRZXX.HRZMC AS hrzmc,
ENERGY_DAYHEATINFO.NIANDU AS niandu,
ENERGY_DAYHEATINFO.RQDATE AS rqdate,
ENERGY_DAYHEATINFO.SJRNH AS sjrnh,
ENERGY_DAYHEATINFO.Sfmj as sfmj
from ENERGY_DAYHEATINFO,GG_HRZXX
where ENERGY_DAYHEATINFO...
转载
2020-06-03 14:18:40 ·
465 阅读 ·
0 评论