SQL Server 2012：在单个列中返回多个字符串以获取公共行ID

作者: 镜乃Kagamino
发布时间: 2024-08-13 03:41:30 (13天前)
转自：

2 条回复

0#
回复此人
句号了哦哦 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 请试试这个： </p> <pre> <code> SELECT playerID, yearID, awards = STUFF( (select ',' + [awardID] from AwardsPlayers t where playerID = AwardsPlayers.playerID and yearID = AwardsPlayers.yearID for xml path('')) , 1 , 1 , '') FROM AwardsPlayers GROUP BY playerID, yearID </code> </pre> </DIV>

编辑

登录后才能参与评论