/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 vote294 views1 answer
What is between operator
SQL
0 vote304 views1 answer
How to output a different column name in mysql
SQL
0 vote314 views2 answers
Oracle select
SQL
13 votes304 views5 answers
Sql default
SQL
0 vote292 views1 answer
If null don't update
SQL
-3 votes332 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote341 views2 answers
Full join
SQL
2 votes300 views1 answer
Plsql block
SQL
3 votes300 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
3 votes293 views2 answers
Sqlite show table definition
SQL