ITeye博客

查某id字段一样的多条记录,为将另一字段合并起来

java_frog · 2010-12-03 13:28 · personal · 数据库 · Markdown

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逗号隔开合到一条记录里。

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。