SELECT LTRIM(MAX(SYS_CONNECT_BY_PATH(dkwz, ', ')), ', ') AS aa
FROM(
SELECT '1' as id, dkwz,
ROW_NUMBER() OVER (PARTITION BY '1' ORDER BY dkwz) AS curr,
ROW_NUMBER() OVER (PARTITION BY '1' ORDER BY dkwz) -1 AS prev
FROM t_yw_tdcr_data_crsqdj
--where 条件
order by dkwz
)
START WITH curr = 1
CONNECT BY prev = PRIOR curr AND id = PRIOR id
GROUP BY id
FROM(
SELECT '1' as id, dkwz,
ROW_NUMBER() OVER (PARTITION BY '1' ORDER BY dkwz) AS curr,
ROW_NUMBER() OVER (PARTITION BY '1' ORDER BY dkwz) -1 AS prev
FROM t_yw_tdcr_data_crsqdj
--where 条件
order by dkwz
)
START WITH curr = 1
CONNECT BY prev = PRIOR curr AND id = PRIOR id
GROUP BY id