DB2
WITH x(key, val, rnum) AS ( SELECT fkey, col1, row_number() over(partition by fkey) FROM myTable ), y(key, str, cnt, cnt_max) AS ( SELECT key, VARCHAR('', 1000), 0, MAX(rnum) FROM x GROUP BY key UNION ALL SELECT y.key, y.str || RTRIM(CHAR(x.val)), y.cnt + 1, y.cnt_max FROM x, y WHERE x.key = y.key AND x.rnum = y.cnt + 1 AND y.cnt < y.cnt_max ) SELECT key, str FROM y WHERE y.cnt = y.cnt_max; http..
더보기