Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    153

    Unanswered: how to merge the values of a particular column?

    HI guys.

    i have a table containing details like

    name class roll
    ------ ------- -------

    ram 1 12
    shyam 2 13
    hari 1 14


    i want result like based on class i want to merge the name. suppose if class is 1 then name should be "ramhari" i want to fetch merged values and get it inserted in different table.


    Thanks guys

    []

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    take a look at pivot or recursive sql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •