如何将行记录格式化为列明智
问题描述：
SubjectID学生姓名
---------- -------------
1玛丽
1约翰
1山姆
2阿拉娜
2爱德华
我期望的结果:
SubjectID列1列2列3
1玛丽·约翰·山姆
2艾伦·爱德华
等等...
SubjectID StudentName
---------- -------------
1 Mary
1 John
1 Sam
2 Alaina
2 Edward
Result I am expecting:
SubjectID Column1 Column2 Column3
1 Mary John Sam
2 Alaina Edward
etc...
答
此链接可帮助您
http://www.c-sharpcorner.com /uploadfile/suthish_nair/convert-rows-to-columns-in-sql-server-20082005/ [
this link help you
http://www.c-sharpcorner.com/uploadfile/suthish_nair/convert-rows-to-columns-in-sql-server-20082005/[^]
What is you looking for also called as Pivot table in excel.
类似的问题在这里，我也给出了答案:
将行转换为列 [
Similar question is here and I have given answer for that as well:
convert rows into columns[^]