楼上decode 好像就是DB2 pivot. 的用法,Rows 转columns ,再组成一个字段即可。
https://www.ibm.com/developerworks/community/blogs/SQLTips4DB2LUW/entry/pivoting_tables56?lang=en
https://www.ibm.com/developerworks/community/blogs/SQLTips4DB2LUW/entry/pivoting_tables56?lang=en
https://goo.gl/BWFC6d网址被截断重贴