/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 vote178 views1 answer
Select from another database
SQL
1 vote190 views1 answer
Query for all indexes in table postgres
SQL
0 vote184 views3 answers
Convert sql query to python pandas
SQL
0 vote223 views1 answer
Sql doesn't contain
SQL
0 vote176 views2 answers
Sql if empty then
SQL
0 vote189 views1 answer
Oracle sql log to console
SQL
3 votes178 views1 answer
Search for column name in psql
SQL
1 vote193 views1 answer
Oracle sequence last_number
SQL
-1 vote152 views1 answer
Mysql if example
SQL
0 vote177 views1 answer
Get duplicate entry sql
SQL