/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 vote285 views1 answer
Run docker container with database as rds metabase
SQL
18 votes192 views4 answers
Uninstall mysql on ubuntu
SQL
4 votes226 views1 answer
Search column by name mysql
SQL
3 votes205 views1 answer
Oracle revoke
SQL
0 vote214 views1 answer
Sql put two columns into one
SQL
2 votes207 views3 answers
Row number mysql
SQL
0 vote223 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote213 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote204 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote201 views1 answer
Adding generated time in row mysql workbench
SQL