Post reply

Please Try to give this format..

  • June 23, 2009 at 11:32 pm

    #133435

    Dear all

    I have a output like this

    COLUMNS ARE : MARCH APRIL MAY

    ROWS ARE :

    10 0 20

    0 20 21

    11 0 0

    But i need this format..

    COLUMNS ARE : MARCH APRIL MAY

    ROWS ARE

    10 20 20

    11 0 21

    Any onew can help me?..

    please

  • June 23, 2009 at 11:48 pm

    #1014435

    What is the table structure and also give the query you are using to get the output.

    Tanx 😀

  • June 23, 2009 at 11:55 pm

    #1014437

    A table having the columns are

    January_id ,March_id , april_id

    If i

    select January_id ,March_id , april_id from table

    it shows the values

    10 , 0 , 20

    0 , 5 , 0

    here I need to avoid the extra rows

    10 , 5 ,20

    can we do?

  • June 24, 2009 at 12:18 am

    #1014443

    Saravanan_tvr (6/23/2009)

    it shows the values

    10 , 0 , 20

    0 , 5 , 0

    here I need to avoid the extra rows

    10 , 5 ,20

    can we do?

    Hi,

    like this

    select sum(Jan_id),sum(feb_ig),sum(mar_id).....

    ARUN SAS

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply