/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 vote336 views4 answers
Mysql count table rows
SQL
1 vote315 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote362 views1 answer
MySQL update with subquery
SQL
0 vote335 views1 answer
Mysql join only one column
SQL
0 vote318 views1 answer
Mysql select all where count more than"
SQL
4 votes402 views4 answers
Remove duplicate old value in mysql
SQL
1 vote321 views1 answer
Oracle user last connected
SQL
0 vote332 views1 answer
Day of the week sqlite
SQL
1 vote348 views3 answers
Nth highest salary
SQL
0 vote317 views1 answer
Mysql begin statement
SQL