How to sum by multiple columns conditions (SQL)

Question

It's a bit difficult to explain what I'm trying to do (sorry for the hard to read title), but basically I want to sum repeat rows like so:

Table A:

EntryID| Country | Region | Sales 
101    | USA     | North  | $10
102    | USA     | North  | $5
103    | USA     | South  | $15
104    | USA     | South  | $10
105    | CHINA   | North  | $5
106    | CHINA   | North  | $5
107    | CHINA   | South  | $10
108    | CHINA   | South  | $20

Desired Output:

EntryID| Country | Region | Sales 
101    | USA     | North  | $15
103    | USA     | South  | $25
105    | CHINA   | North  | $10
107    | CHINA   | South  | $30

How can I do this?

In your desired output, are you sure that EntryID is correct for each row? (I would imagine more than one EntryID for some rows...) — Grantly
– Grantly, Commented Dec 28, 2016 at 18:24

Gurwinder Singh · Accepted Answer · 2016-12-28 18:26:53Z

4

The SQL statement has to look like:

SELECT MIN(EntryID) AS EntryID,
  Country,
  Region,
  SUM(Sales) AS Sales
FROM TABLE
GROUP BY Country,
  Region

edited Dec 28, 2016 at 18:26

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

answered Dec 28, 2016 at 18:22

André

3432 silver badges9 bronze badges

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

1 Comment

Gurwinder Singh Over a year ago

Formatted the query :)

sstan · Accepted Answer · 2016-12-28 18:22:12Z

0

Details are lacking, but it sounds like a simple GROUP BY to me:

select min(EntryID), Country, Region, sum(sales)
  from tbl
 group by Country, Region

answered Dec 28, 2016 at 18:22

sstan

36.8k7 gold badges54 silver badges72 bronze badges

Collectives™ on Stack Overflow

How to sum by multiple columns conditions (SQL)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related