/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

0 vote304 views2 answers
Install phoenix
SQL
0 vote270 views1 answer
Expose db in virtualbox
SQL
0 vote312 views1 answer
Declarative base sqlalchemy
SQL
0 vote334 views2 answers
SQL FROM
SQL
-1 vote274 views1 answer
Mysql if example
SQL
0 vote331 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote330 views1 answer
Add a new column into table
SQL
8 votes320 views2 answers
Python simple connect to mysql
SQL
0 vote315 views1 answer
Mysql update table from select on another table
SQL
0 vote337 views1 answer
Suhaib
SQL