Is it possible to convert multiple rows to a single column?

Kanaparthi Sureshma Reddy

11y954

Is it possible to convert multiple rows to single column?
For Ex,
I have table like this,
       id   name subname   marks
        1   abc    C         10
        1   abc    JAVA      20
        1   abc    DAA       30
        2   xyz    C         30
        2   xyz    JAVA      20
        2   xyz    DAA       10
          In this case the rows should converted into columns and the subname should come only once as column in the table like this.

       id name   C      JAVA     DAA
        1   abc 10       20       30
        2   xyz 30       20       10
            Is it possible? If possible please help me....

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Govinda Rajulu Yemineni11y ago
Hi,

SELECT [ID],[Name],[C],[JAVA],[DAA]
FROM
(
      SELECT [ID],[Name],[subname],[marks] FROM tbl_student_marks_Details
) AS S
PIVOT
(
      SUM([marks])
      FOR [subname] IN([C],[JAVA],[DAA])
) AS PivotTable
ORDER BY [ID]
0
Pankaj Kumar Choudhary11y ago
Hello @sureshma you can visit these links

http://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/
http://raresql.com/tag/merge-or-combine-multiple-rows-records-to-single-column-record-with-comma-delimiters/
0
Rajeesh Menoth11y ago
Hi,

Try this : http://www.codeproject.com/Questions/633043/how-to-convert-multiple-row-in-a-single-column-usi
0