select 编号,wm_concat(体质) 体质 from table_name group by 编号
--10g及以上可用wm_concat --9i及以下可用 SELECT a.编号, ltrim(MAX(sys_connect_by_path(体质, '、')), '、') 体质 FROM (SELECT row_number() over(PARTITION BY t.编号 ORDER BY t.编号) rn, t.* FROM 表名 t) a START WITH rn = 1 CONNECT BY PRIOR rn = rn - 1 AND a.编号=PRIOR a.编号 GROUP BY a.编号;
select 编号,wm_concat(体质) 体质
from table_name
group by 编号
--9i及以下可用
SELECT a.编号, ltrim(MAX(sys_connect_by_path(体质, '、')), '、') 体质
FROM (SELECT row_number() over(PARTITION BY t.编号 ORDER BY t.编号) rn, t.* FROM 表名 t) a
START WITH rn = 1
CONNECT BY PRIOR rn = rn - 1 AND a.编号=PRIOR a.编号
GROUP BY a.编号;