有没有字符串的sum函数可以拼接组内某字符字段
有没有字符串的sum函数可以拼接组内某字符字段
有没有字符串的sum函数可以group by之后吧某个字段都拼接起来 类似于 select sum(char_field) from T group by A_field收起
有没有字符串的sum函数可以group by之后吧某个字段都拼接起来 类似于 select sum(char_field) from T group by A_field收起
查看其它 6 个回答ppjava2009的回答
listagg就可以啊，以下为一例：
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,subname,score)
GROUP BY stno;
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,subname,score)
GROUP BY stno;
浏览2042