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

Govinda Rajulu Yemineni · Answer

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]

Pankaj Kumar Choudhary · Answer

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/

Rajeesh Menoth · Answer

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