How to write a TSQL query?

Question

SQL

There is a table like
num | text
----------------
1 | name1
2 | name2
2 | name3
2 | name4
3 | name5
how to write a query to display data like this
num | all_text
------------
1 | name1
2 | name2, name3, name4
3 | name5

Answer 1

Data:
Request:

SELECT
T1.Id,

(SELECT concat(T2.Name, '; ') 
FROM dbo.Test AS T2
WHERE T2.Id = T1.Id
FOR XML PATH('')) AS Name

FROM
dbo.Test AS T1
GROUP BY T1.Id

Result:

Answer 2

STRING_AGG (Transact-SQL)

SELECT num, STRING_AGG(text, ', ') AS all_text
FROM <tablename>
GROUP BY num;