SQL query to join rows with same values

Question

I've come across a problem that I don't really know how to solve. I have a table which looks somewhat like this:

ID   Name     Price     Quantity
1    BookA      5         10
2    BookB     10         15
3    BookA     15         15
4    BookA      5         25

How could I join rows which have same Name, same Price and sum Quantity? So it would look like this:

ID   Name     Price     Quantity
1    BookA      5         35
2    BookB     10         15
3    BookA     15         15

Thank you in advance!

JNevill · Accepted Answer · 2020-04-08 13:57:22Z

1

This is just a simple GROUP BY query:

SELECT Min(ID), Name, Price, Sum(Quantity) as Quantity
FROM yourtable
GROUP BY Name, Price;

answered Apr 8, 2020 at 13:57

JNevill

50.6k4 gold badges46 silver badges71 bronze badges

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

1 Comment

This is what I was looking for! Thank you, Sir