/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

14 votes370 views3 answers
Inner join sql oracle
SQL
0 vote355 views1 answer
Mysql select inside sum
SQL
0 vote330 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote339 views1 answer
Is not sql
SQL
0 vote353 views1 answer
Select nth row in mysql
SQL
0 vote337 views2 answers
Sql update top 100
SQL
0 vote363 views1 answer
Sort by
SQL
0 vote341 views1 answer
Get last date join sql
SQL
1 vote341 views1 answer
Check if mysql is installed
SQL
0 vote332 views1 answer
Add alternate add column sql
SQL