/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 vote226 views1 answer
In query in sql
SQL
0 vote196 views1 answer
Mysql insert into select with recursive
SQL
0 vote197 views1 answer
Sql drop default
SQL
3 votes208 views1 answer
How to uninstall microsoft sql server
SQL
0 vote211 views1 answer
Dbms_output sql developer
SQL
12 votes208 views2 answers
Delete all nodes neo4j
SQL
3 votes462 views1 answer
Postgresql cast
SQL
0 vote214 views1 answer
Update database collation in postgresql
SQL
0 vote190 views1 answer
Insert or update cassandra
SQL
0 vote219 views1 answer
Query for backup a database at another location in file system
SQL