作者licheer (Keep The Faith)
看板Database
标题[SQL ] 在VBA中合并字串
时间Fri Oct 13 22:18:03 2017
资料库名称：MS SQL
内容/问题描述：
NAME MEMO
1 A,B
2 C,D,E,F
1 J,K,L
1 M,N
==========================
1 A,B,J,K,L
下面这个方法最多只能加两次,第三次以上M,N就没办法了
请问可以怎麽写才能把所有栏位的字串相加呢? 谢谢
SELECT name,(select top 1 memo from a as k where k.name = i.name order by
memo desc) & (select top 1 (',' & memo) from a where name in ((select name
from a as j where i.name = j.name group by name having count(name) > 1))
order by memo ) as memo FROM a AS i GROUP BY name order by name desc;
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 111.246.92.215
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Database/M.1507904285.A.297.html