/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 vote138 views1 answer
Query for maximum salary
SQL
0 vote157 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
2 votes200 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote158 views2 answers
Mysql spring boot application.properties
SQL
2 votes126 views1 answer
Sql float to int
SQL
0 vote208 views1 answer
Sql select first and last record of each group
SQL
1 vote169 views1 answer
Postgresql define pk sequence next number
SQL
3 votes124 views1 answer
Ubuntu install postgresql 12
SQL
-2 votes182 views1 answer
Mysql see users and passwords
SQL
0 vote168 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL