如何通过以逗号分隔的行连接来获取不同的记录 [英] How to Get distinct record by concatenating rows in comma separated

问题描述

FacultyName Mobile CourseName-Section IsAdjunct

Faria 0333 * 23 * 13 * CS3612软件工程-II-A 0

Faria 0333 * 2 ** 13 * CS3612软件工程-II-B 0

Faria 0333 * 2 ** 13 * CS3612软件工程-II-C 0





如何通过在sql server 2008中连接列CourseName-section这样得到不同的记录，



Faria 0333 * 23 * 13 * CS3612软件工程-II-（A，B，C）0





先谢谢你，

FacultyName Mobile CourseName-Section IsAdjunct
Faria 0333*23*13* CS3612 Software Engineering-II-A 0
Faria 0333*2**13* CS3612 Software Engineering-II-B 0
Faria 0333*2**13* CS3612 Software Engineering-II-C 0


How can i get distinct record by concatenating column CourseName-Section like this in sql server 2008,

Faria 0333*23*13* CS3612 Software Engineering-II-(A,B,C) 0


Thank You in Advance,

推荐答案

看看这个提示 [ ^ ]。

它向您展示了技术。

Have a look at this tip[^].
It shows you the technique.

这篇关于如何通过以逗号分隔的行连接来获取不同的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！