/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 vote194 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote189 views1 answer
Mysql export search results
SQL
1 vote382 views1 answer
Postgres convert text to number
SQL
4 votes205 views1 answer
Adding data to table in sql python
SQL
14 votes185 views4 answers
Remove record from table sql
SQL
0 vote188 views1 answer
How to check xampp mysql password
SQL
0 vote178 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote185 views1 answer
Csv to sqlite python
SQL
0 vote202 views1 answer
Extract sql from query object sqlalchemy
SQL
7 votes192 views2 answers
What is sql clause
SQL