SQL Count/sum multiple columns

Question

I want to use count/ sum multiple fields in a single query sample data and desired result is as listed below:

MemID  claimNum  ItemID PaidAmt 
123    1234      4      5
123    2309      4      5 
123    1209      4      5 
123    1209      8      2.2
123    1210      8      2.2

Desired result

MemID  count(claimNum) count(ItemID) sum(PaidAmt) 
123    3               3             15 
123    2               2             4.4

Why are you counting both claims and items? Also, this is a simple aggregation query, so you should show what you have tried. — Gordon Linoff
– Gordon Linoff, Commented Apr 21, 2016 at 18:45

user212514 · Accepted Answer · 2016-04-21 18:50:14Z

1

It looks like you want to group by both MemID and ItemID:

select MemID, count(claimNum), count(ItemID), sum(PaidAmt) 
  from the_table 
group by MemID, ItemID

answered Apr 21, 2016 at 18:50

user212514

3,1381 gold badge17 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScaisEdge · Accepted Answer · 2016-04-21 18:55:15Z

0

Use group by ItemID

select MemID, count(claimNum), count(ItemID), sum(PaidAmt) 
from my_table 
group by MemID, ItemID

edited Apr 21, 2016 at 18:55

answered Apr 21, 2016 at 18:46

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Collectives™ on Stack Overflow

SQL Count/sum multiple columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related