查某id字段一样的多条记录,为将另一字段合并起来
SELECT productcode, TRANSLATE (LTRIM (text, '/'), '/', ',') name FROM (SELECT ROW_NUMBER () OVER (PARTITION BY productcode ORDER BY productcode, lvl DESC) rn, productcode, text FROM (SELECT productcode, LEVEL lvl, SYS_CONNECT_BY_PATH (name,'/') text FROM (SELECT productcode, name as name, ROW_NUMBER () OVER (PARTITION BY productcode ORDER BY productcode,name) x FROM busi_financing_person ORDER BY productcode, name) a CONNECT BY productcode = PRIOR productcode AND x - 1 = PRIOR x)) WHERE rn = 1 ORDER BY productcode
如把productcode字段相同的多条记录中的name逗号隔开合到一条记录里。