/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

2 votes102 views1 answer
Oracle kill job by sid
SQL
12 votes103 views3 answers
Duplicate a column in sql
SQL
0 vote109 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote114 views1 answer
Install postgresql on raspberry pi
SQL
3 votes119 views3 answers
Restart mysql mac
SQL
35 votes109 views6 answers
Postgres
SQL
-1 vote110 views3 answers
Update mongodb version ubuntu
SQL
0 vote105 views1 answer
Postgres read table structure
SQL
3 votes119 views3 answers
1396(hy00) mysql error
SQL
0 vote106 views1 answer
Sql where part of string match
SQL