/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 vote303 views1 answer
Group by join columns per table
SQL
0 vote300 views1 answer
Oracle current timestamp
SQL
1 vote297 views3 answers
Rename table snowflake
SQL
1 vote312 views1 answer
Epoch time converter in snowflake
SQL
1 vote316 views1 answer
Mysql print variable
SQL
0 vote307 views1 answer
Mysql extract day from date leading zero
SQL
0 vote320 views1 answer
Neo4j command to run script file
SQL
7 votes286 views4 answers
Database dump mysql command
SQL
0 vote301 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote313 views1 answer
Base64 encode sql server
SQL