/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

4 votes123 views1 answer
Mysql ip address data type
SQL
3 votes118 views2 answers
Oracle sql select all days between two dates except weekends
SQL
1 vote124 views1 answer
How to remove identity from a column in sql server
SQL
-1 vote117 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote116 views1 answer
Connect by query in oracle
SQL
0 vote114 views1 answer
Oracle SQL join three tables and group by column
SQL
7 votes114 views1 answer
Mysql remote connection command line
SQL
0 vote117 views1 answer
Sql insert from excel
SQL
1 vote119 views1 answer
Best sql course
SQL
1 vote115 views1 answer
Update foreign key value in mysql
SQL