Click here to Skip to main content
12,897,830 members (67,943 online)
Click here to Skip to main content
Add your own
alternative version

Stats

67.4K views
6 bookmarked
Posted 10 Aug 2013

SQL: Column Values as Comma Separated String

, 10 Aug 2013 CPOL
Rate this:
Please Sign up or sign in to vote.
Column values as comma separated string in SQL

Introduction

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.

SQL Statement

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

print @str 

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Srinivas Kalabarigi
Technical Lead
India India
No Biography provided

You may also be interested in...

Comments and Discussions

 
Questioncoalesce query Pin
Tirthankar Dey1-Sep-13 21:24
memberTirthankar Dey1-Sep-13 21:24 
QuestionWhat about NULL values? Pin
kast21815-Aug-13 23:47
memberkast21815-Aug-13 23:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170424.1 | Last Updated 10 Aug 2013
Article Copyright 2013 by Srinivas Kalabarigi
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid