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

preview_player
Показать описание
COALESCE
String_AGG

1. DECLARE @countryNames VARCHAR(MAX)
FROM [Country]
SELECT @countryNames

2. SELECT STRING_AGG(Country_Name,' ') As NamesInSingleRow
FROM [Country]
Рекомендации по теме
visit shbcf.ru