/SQL/Tsql join multiple record in one string

Tsql join multiple record in one string

-- Concatenates results into one single varchar with separator
SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name)
FROM YOUR_TABLE;

Tsql join multiple record in one string

Select CountryName from Application.Countries 
 
Declare @val Varchar(MAX); 
Select @val = COALESCE(@val + ', ' + CountryName, CountryName) 
        From Application.Countries Select @val;

Source: mytecbits.com

Similar codes

5 votes189 views1 answer
Ignore duplicate rows in sqlite
SQL
16 votes209 views4 answers
Ascending order mysql
SQL
0 vote195 views1 answer
Connect by query in oracle
SQL
0 vote184 views1 answer
Number(10 2) in sql means
SQL
1 vote337 views2 answers
Sql unique rows
SQL
1 vote204 views2 answers
Create table if not exist
SQL
0 vote205 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote194 views1 answer
MySQL - How to find word with the most similar beginning
SQL
12 votes193 views4 answers
Mysql version
SQL
0 vote199 views1 answer
Mssql disable foreign key constraint
SQL