1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

how to convert the colum header and one row into another table with many rows

Discussion in 'SQL - Repository' started by samhpai@sqlrecipes.com, Feb 12, 2009.

  1. samhpai@sqlrecipes.com New Member

    if column headers are: btwn0n10
    btwn10n20
    btwn20n30
    above30

    and each column has just one value in it
    then how to convert it into a table with individual rows with the values in seperate column?

    ters no way to xtract the same info from the main table as the indivdual rows cant be clubed on any basis...pl help
    samhpai@sqlrecipes.com, Feb 12, 2009
    #1

  2. jisha New Member


    Can u show the sample as to how u want to view the data....
    It would be easier to suggest if possible
    jisha, May 21, 2009
    #2

  3. my_s_e_l_f New Member

    It can be clubbed in oracle. What database are you using?
    my_s_e_l_f, Jul 19, 2009
    #3

Share This Page