Link to home
Start Free TrialLog in
Avatar of Amour22015
Amour22015

asked on

SQL Server 2012 r2 - Sum totals

Hi Experts,

I have this part of query:
Select Distinct
                              AB.Scandate, 
                              AB.Category, 
                              AB.Plugin, 
                              AB.IPLong,
                              Count(*) as Total 
From #tmpbaseline AB -- Above Base line
Group By AB.Scandate, 
                              AB.Category, 
                              AB.Plugin, 
                              AB.IPLong

Open in new window


But this gives a laundry list of total.

Like:
User generated image

I need something like:
Sum( Count(*)) as Total

I need it to sum up the total per each Category
So  Above baseline would have like:
Above baseline 82100


Please help and thanks...
ASKER CERTIFIED SOLUTION
Avatar of Kyle Abrahams, PMP
Kyle Abrahams, PMP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Amour22015
Amour22015

ASKER

Yes, thanks that is what I am looking for...