Post reply

Need help on Sum and Grouping

  • October 5, 2016 at 10:06 pm

    #313611

    Hello,

    How to sum(hr_baki_tlepas), sum(hr_tmbh_semasa), sum(hr_lupus), sum(hr_kos_harta), sum(sn_baki_tlepas), sum(sn_tmbh_semasa), sum(sn_lupus), sum(sn_kos_harta), sum(nilai_bersih) Group By year_num, kwang_code_desc, chart_code?

  • October 6, 2016 at 3:15 pm

    #1905279

    Qira (10/5/2016)

    Hello,

    How to sum(hr_baki_tlepas), sum(hr_tmbh_semasa), sum(hr_lupus), sum(hr_kos_harta), sum(sn_baki_tlepas), sum(sn_tmbh_semasa), sum(sn_lupus), sum(sn_kos_harta), sum(nilai_bersih) Group By year_num, kwang_code_desc, chart_code?

    So what is the issue with the results if you do exactly what you just posted? That would just be:

    select year_num, kwang_code_desc, chart_code, sum(hr_baki_tlepas), sum(hr_tmbh_semasa), sum(hr_lupus),

    sum(hr_kos_harta), sum(sn_baki_tlepas),

    sum(sn_tmbh_semasa), sum(sn_lupus), sum(sn_kos_harta), sum(nilai_bersih)

    from tmpaccthist_2013_2014_report_2_nota3

    Group By year_num, kwang_code_desc, chart_code

    Sue

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

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