/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 votes257 views6 answers
List all tables in postgres
SQL
0 vote232 views2 answers
Sql update top 100
SQL
17 votes235 views6 answers
Mysql import sql file
SQL
0 vote266 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
3 votes225 views1 answer
Index using in query plsql
SQL
0 vote236 views1 answer
Postgres data location
SQL
3 votes235 views1 answer
Sql is not like
SQL
3 votes226 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote226 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote237 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL