iSebbeYT
Reputation: 1521
SQL Query SELECT table that sum all values where two others are equal
I have the following table ("Have"). What would be a proper way to SELECT a table where you sum the value of C where A and B are equal. So that you get the result displayed in "Want".
Upvotes: 0
Views: 36
Answers (1)
Sphinx
Reputation: 10729
use group by then sum.
select A, B, sum(c) from your_table group by A, B
Upvotes: 3
Related Questions
- SELECT SUM WHERE multiple values even if are equals
- Mysql select rows where sum is equal to
- MySQL - Select Rows where Sum(rows) = something
- SQL query to find rows where a column value is equal to the sum of tow other columns in the same row
- mysql - select from a table with sum() and where clause
- MySQL select rows where its columns sum equal value
- MySQL: Sum if rows are equal
- How to sum value if both rows are equal?
- Retrieving records where sum of same columns with some condition
- SUM a column when another column has equal values