这样一个表
TOBACCOID COMPANYID
1945 342
1945 1
1945 14
1951 130
1951 55
1951 14
1952 55
1952 130
1952 342
1958 183
1958 55
1958 342
这样的表我要将TOBACCOID相同的COMPANYID连接成一个字符串,怎么做的,
如1945 342连接1连接14
1951 130连接55连接14
TOBACCOID COMPANYID
1945 342
1945 1
1945 14
1951 130
1951 55
1951 14
1952 55
1952 130
1952 342
1958 183
1958 55
1958 342
这样的表我要将TOBACCOID相同的COMPANYID连接成一个字符串,怎么做的,
如1945 342连接1连接14
1951 130连接55连接14
A 1
A 2
A 3 用一条sql语句查询成:
field1 all A 1,2,3,
mysql:select field1,group_concat(field2) as all from table group by field1 Oracle:
SELECT field1, all
FROM (SELECT field1,
row_number() over(PARTITION BY field1 ORDER BY field2) AS rn,
field2 || lead(',' || field2, 1) over(PARTITION BY field1 ORDER BY field2) ||
lead(',' || field2, 2) over(PARTITION BY field1 ORDER BY field2) ||
lead(',' || field2, 3) over(PARTITION BY field1 ORDER BY field2) AS all
FROM table1)
WHERE rn = 1
ORDER BY 1; Oracle:
SELECT a ,WMSYS.WM_CONCAT(b)
FROM tab1
GROUP BY a;
oracle 10g以上可用wm_concat, 等价于mysql 的 group_concat