SQL 列内容合并

CREATE TABLE TMP10
(
   JS   NUMBER (8),
   ND   NUMBER (4),
   JM   VARCHAR2 (50)
);


INSERT INTO TMP10 (JS, ND, JM)
     VALUES (10, 2006, ‘DAQING01’);


INSERT INTO TMP10 (JS, ND, JM)
     VALUES (20, 2007, ‘DAQIN03’);


INSERT INTO TMP10 (JS, ND, JM)
     VALUES (30, 2006, ‘SHENGLI01’);




INSERT INTO TMP10 (JS, ND, JM)
     VALUES (40, 2007, ‘KELAMAYI01’);




INSERT INTO TMP10 (JS, ND, JM)
     VALUES (10, 2006, 'DAQING01');


INSERT INTO TMP10 (JS, ND, JM)
     VALUES (20, 2007, 'DAQIN03');


INSERT INTO TMP10 (JS, ND, JM)
     VALUES (30, 2006, 'SHENGLI01');


INSERT INTO TMP10 (JS, ND, JM)
     VALUES (40, 2007, 'KELAMAYI01');


    SELECT ND,
           SUM (JS) SUM_JS,
           MAX (LTRIM (SYS_CONNECT_BY_PATH (JM, ','), ',')) SUM_JM
      FROM (SELECT ND,
                   JS,
                   JM,
                   ROW_NUMBER () OVER (PARTITION BY ND ORDER BY JS) RN
              FROM TMP10)
START WITH RN = 1
CONNECT BY PRIOR RN + 1 = RN AND PRIOR ND = ND
  GROUP BY ND;