同一个字段显示同一行

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