关于oracle行合并sql查询问题

[lysamper]

表结构数据如下
id name attr
1 aa mm
1 aa nn
2 bb kk
2 bb lll
1 bb oo
我想通过sql来实现如下结构

id name attr
1 aa mm，nn
1 bb oo
2 bb kk，lll


这样能通过sql实现吗？？

[HelloWorld_001]

又是这问题，查下以前的帖子就有了
下面是例子

WITH A AS (
SELECT 1123 ID,'2008-9-19' DAY,'9:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'19:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'13:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'12:7:47' TIME FROM DUAL )
select ID,DAY,WMSYS.WM_CONCAT(TIME) TIME FROM A GROUP BY ID,DAY
/

ID DAY TIME ---------- --------- ------------------------------------------------------------
1123 2008-9-19 12:7:47,13:7:47,19:7:47,9:7:47



10G及以上的版本可以這樣寫

第二中方法

SQL code

WITH A AS (
SELECT 1123 ID,'2008-9-19' DAY,'9:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'19:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'13:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'12:7:47' TIME FROM DUAL )
select ID,DAY,MAX(SYS_CONNECT_BY_PATH(TIME,',')) TIME FROM
(SELECT ID,DAY,TIME,ROW_NUMBER()OVER(PARTITION BY ID,DAY ORDER BY ID ) RN FROM A)
START WITH RN=1
CONNECT BY RN-1=PRIOR RN
GROUP BY ID,DAY

[zhu_gx]

楼上牛

[idisee]

利用一个构造函数.

[kanxue660]

网上很多，看下就明白了

[pccastle]

jf

[pccastle]

不错

[UltraBejing]

不明LZ在说什么

[meiZiNick]

不明LZ在说什么