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

Question

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....
 

Answer 1

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]

 

Answer 2

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/ 

Answer 3

Hi,

 

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