db2分组后上下合并不一样的列
1、SELECT stno,LISTAGG(subname||' '||score,',') WITHIN GROUP(ORDER BY 1) info FROM (VALUES ('NO01','语文',90) , ('NO01','数学',99) , ('NO01','英语',98) , ('NO02','语文',96),('NO02','数学',95)) AS t(stno,sub...
原创
2014-12-22 18:04:44 ·
614 阅读 ·
0 评论