DB2列转行SQL
–单表数据
SELECT gz.LRRQ,gz.HYDH,gz.ckkh,gz.ywlkh,gz.sfgz
FROM SGLR_HYSFGZB gz
WHERE gz.LRRQ=202103 AND gz.HYDH=‘309030149’
–DB2列转行
SELECT gz.LRRQ,gz.HYDH,a.jxlb,a.gz
FROM SGLR_HYSFGZB gz
INNER JOIN TABLE(
VALUES
(‘存款考核’,gz.ckkh),
(‘业务量考核’,gz.ywlkh),
(‘实发工资’,
原创
2021-10-20 17:41:22 ·
1978 阅读 ·
0 评论