Append the data in multiple Rows to single row

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shivakrishna
    New Member
    • Oct 2008
    • 3

    Append the data in multiple Rows to single row

    hi i need a query to format the data

    the raw data is as follows

    ID skills
    1001 sql
    1001 C++
    1001 java
    1002 unix
    1002 C++
    1003 rdbms
    1003 java

    and the result must be

    ID skills
    1001 sql , C++, java
    1002 unix , C++
    1003 rdbms , java
  • coolsti
    Contributor
    • Mar 2008
    • 310

    #2
    Hint: look in the mysql documentation for the "group by" clause and the "group_concat() " function.

    Comment

    Working...