/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

8 votes140 views1 answer
Oracle search source code
SQL
0 vote140 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote143 views1 answer
Mysql create pool
SQL
1 vote137 views1 answer
Get rows affected mysql python
SQL
1 vote148 views1 answer
SQL Integer devision
SQL
0 vote140 views1 answer
Postgres can integer fields be negative
SQL
0 vote143 views1 answer
Oracle exchange partition
SQL
1 vote221 views1 answer
Mysql breakline on string
SQL
0 vote146 views1 answer
SQL server datetime compare
SQL
0 vote143 views1 answer
SQL Query to delete all the tables in a database
SQL