/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

1 vote136 views1 answer
Right outer vs left outer join
SQL
0 vote138 views1 answer
Sql datediff month
SQL
0 vote146 views1 answer
Sql ignore
SQL
1 vote170 views1 answer
Postgresql if 0 then 1
SQL
0 vote147 views1 answer
Sql server on mac m1
SQL
0 vote130 views1 answer
User defined variables in sql
SQL
0 vote171 views1 answer
ORACLE PARSE STRING
SQL
2 votes153 views1 answer
Install postgresql centos 5
SQL
4 votes130 views3 answers
Order by value mysql
SQL
0 vote107 views1 answer
Copy data from cell to cell mysql
SQL