filmov
tv
SQL Queries||Two ways to concatenate Text from Multiple rows into single row

Показать описание
COALESCE
String_AGG
1. DECLARE @countryNames VARCHAR(MAX)
FROM [Country]
SELECT @countryNames
2. SELECT STRING_AGG(Country_Name,' ') As NamesInSingleRow
FROM [Country]
String_AGG
1. DECLARE @countryNames VARCHAR(MAX)
FROM [Country]
SELECT @countryNames
2. SELECT STRING_AGG(Country_Name,' ') As NamesInSingleRow
FROM [Country]