ID COL ---------- ---------- 1 a 1 b 1 c 3 c 2 d 2 a 2 d
已选择7行。
SQL> SELECT id, 2 MAX(decode(rn, 1, col, NULL)) || 3 MAX(decode(rn, 2, ',' || col, NULL)) || 4 MAX(decode(rn, 3, ',' || col, NULL)) str 5 from (SELECT id, 6 col, 7 row_number() over(PARTITION BY id ORDER BY col) AS rn 8 from t_row_str) t 9 GROUP BY id 10 ORDER BY 1;
ID STR ---------- -------------------------------- 1 a,b,c 2 a,d,d 3 c
