I have a table as shown below, which has
Country_Code and languages that are spoken by different people living in a country. I need to retrieve distinct languages spoken in a country based on the
Country_Code column as a comma separated string.
The following statement shows how it can be achieved:
declare @str varchar(1000)
SELECT @str= coalesce(@str + ', ', '') + a.CountryLang_Desc
FROM (SELECT DISTINCT CountryLang_Desc from CountryLanguages where Country_Code='IN') a