Watch Pre-recorded Live Shows Here
Why Join
Become a member
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
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Arun Kumar
2.1k
35
10.1k
Merge multiple rows into single row
Sep 19 2015 1:21 AM
My table rows are like below
Id marks
Row1: 1 15
Row2: 1 16
Row3: 1 17
Row4: 2 18
Row5: 2 19
Row6: 2 20
and I want to merge all the rows into a single row , can anybody help me please!!!!
output should be like below
Id marks1 marks2 marks3 Id marks1 marks2 marks3
Row1: 1 15 16 17 2 18 19 20
Reply
Answers (
1
)
Query On Case Statement
Primary key and foreign key