oracle将多条数据合并成一条

select tbr_id ,wm_concat(t.zz_name) as zzName from Gp_Gcjs_Tbr_Zz t  group by tbr_id

 

下面做的一个例子，东西有点多。

 

select rownum as xh, ts.*
  from (select t1.id,
               t2.id as licenseId,
               t3.org_pers_id as persId,
               t1.local_code as loaclCode,
               t1.local_name as localName,
               t1.agc_cn_name as agcCnName,
               t1.bi_reg_addr as biRegAddr,
               t1.local_name as yydz,
               t3.pers_name as faren,
               t3.link_phone as frPhone,
               t3.mobile as frTelePhone,
               t1.contact_people as contactPeople,
               t1.contact_phone as contactPhone,
               t1.phone_num as contactTelePhone,
               t2.rank as rank,
               decode(t2.rank, 1, '甲级', '0', '乙级', '') as rankName,