xmlagg也可以啊,以下为一例:SELECT stno,REPLACE(REPLACE(XML2CLOB(XMLAGG(XMLELEMENT(NAME stno,subname||' '||score||' , '))),''),'') info FROM (VALUES ('NO01','语文',90) , ('NO01','数学',99) , ('NO01','英语',98) ,  ...
显示全部xmlagg也可以啊,以下为一例:
SELECT stno,REPLACE(REPLACE(XML2CLOB(XMLAGG(XMLELEMENT(NAME stno,subname||' '||score||' , '))),'
'),'') info
FROM (VALUES ('NO01','语文',90) , ('NO01','数学',99) , ('NO01','英语',98) ,
('NO02','语文',96),('NO02','数学',95)) AS t(stno,subname,score)
GROUP BY stno;
收起