/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 votes140 views4 answers
2nd highest salary in mysql
SQL
1 vote128 views1 answer
Simple project for database
SQL
0 vote129 views1 answer
Create table database in psql
SQL
0 vote126 views1 answer
Mysql join same table multiple times group by
SQL
8 votes135 views1 answer
Oracle search text in all packages
SQL
0 vote113 views1 answer
Mysql error 1452
SQL
11 votes123 views1 answer
Get ddl materialized view oracle
SQL
4 votes117 views1 answer
Oracle table statistics last analyzed
SQL
0 vote138 views1 answer
How to alter length character varying postgres
SQL
0 vote124 views1 answer
Postgresql remove new line from string
SQL