/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 vote188 views1 answer
Oracle last connection
SQL
2 votes186 views1 answer
Mysql increment value by 1 in update
SQL
8 votes217 views4 answers
Reset SQL auto increment
SQL
0 vote217 views1 answer
How to update date value in sql
SQL
0 vote214 views2 answers
What is the default password for sql server sa
SQL
0 vote198 views1 answer
Where in clause tsql
SQL
2 votes187 views1 answer
How to search table name in stored procedure in sql server
SQL
22 votes308 views4 answers
Mysql date format
SQL
5 votes261 views1 answer
Oracle sysdate - 1 month
SQL
0 vote174 views1 answer
How to connect pgadmin with excel
SQL