TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Vishwas Kadamannaya
1.6k
122
142.6k
Pivoting to a Single Column in SQL
Mar 4 2013 2:09 AM
Hi All,
I have a Database table structure in the following format..
ID
Value
100
ADE
100
BCD
100
CEF
101
MNO
101
PQR
101
XYZ
102
EFG
I want a query to retrieve the results of table in the following format.
ID
Results
100
ADE,BCD,CEF
101
MNO,PQR,XYZ
102
EFG
I know that we can accomplish this by PIVOT Keyword but not able to finalize the query, can you guys help me out Please
Thanks in Advance
Vishwas
Reply
Answers (
2
)
I want School management database structure in detail
selecting and Grouping data