擅长:python、mysql、java
<p>使用<a href="https://docs.microsoft.com/en-us/sql/relational-databases/xml/basic-syntax-of-the-for-xml-clause?redirectedfrom=MSDN&view=sql-server-ver15" rel="nofollow noreferrer">^{<cd1>}</a>-将条目转换为逗号分隔的字符串,使用<a href="http://msdn.microsoft.com/en-us/library/ms188043.aspx" rel="nofollow noreferrer">STUFF</a>()-修剪第一个逗号,如下所示,这将得到相同的逗号分隔结果</p>
<pre><code>SELECT STUFF((SELECT ',' + INSTITUTIONNAME
FROM EDUCATION EE
WHERE EE.STUDENTNUMBER=E.STUDENTNUMBER
ORDER BY sortOrder
FOR XML PATH(''), TYPE).value('text()[1]','nvarchar(max)')
, 1, LEN(','), '') AS listStr
FROM EDUCATION E
GROUP BY E.STUDENTNUMBER
</code></pre>
<p>这是<a href="http://sqlfiddle.com/#!3/ff2c0/1" rel="nofollow noreferrer">FIDDLE</a></p>