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