问题描述
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-A0
Faria 0333*2**13*CS3612 Software Engineering-II-B0
Faria 0333*2**13*CS3612 Software Engineering-II-C0
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,
推荐答案
这篇关于如何通过以逗号分隔的行连接来获取不同的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！