---
title: "查某id字段一样的多条记录，为将另一字段合并起来"
author: "java_frog"
date: "2010-12-03T13:28:19Z"
tags: []
categories: ["数据库"]
slug: "id"
draft: false
lastmod: "2010-12-03T13:28:19Z"
id: 832468
url: "https://java-frog.iteye.com/blog/832468"
---

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