Need distinct sum

• kishore-262367

  SSC Enthusiast

  Points: 111

  More actions

  September 10, 2006 at 1:30 am

  #170246

  Hi ,

  I have a table with two columns CompanyID,Earnings.

  Table ::

                CompanyID     Earnings

                    1                  10

                     1                 20

                    2                   15

  I want sum of sum of earnings according to company i.e

                CompanyID       Earnings

                    1                    30

                    2                    15   

  I have tried using Distinct and GROUP BY, but I didn,t got the answer.

  Reply me asap.

  with regards,

  Kishore

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 10, 2006 at 7:31 am

  #659523

  Select CompanyID, SUM(Earnings) as Earnings From dbo.Companys GROUP BY CompanyID