MySQL - SUM rows with same ID?

To sum rows with same ID, use the GROUP BY HAVING clause.

Let us create a table −

Example

mysql> create table demo84
   -> (
   -> id int,
   -> price int
   -> )
   -> ;
Query OK, 0 rows affected (0.60

Insert some records into the table with the help of insert command −

Example

mysql> insert into demo84 values(1,2000);
Query OK, 1 row affected (0.08

mysql> insert into demo84 values(1,2000);
Query OK, 1 row affected (0.14

mysql> insert into demo84 values(2,1800);
Query OK, 1 row affected (0.14

mysql> insert into demo84 values(2,2200);
Query OK, 1 row affected (0.14

mysql> insert into demo84 values(3,1700);
Query OK, 1 row affected (0.12

Display records from the table using select statement −

Example

mysql> select *from demo84;

This will produce the following output −

Output

+------+-------+
| id   | price |
+------+-------+
|    1 |  2000 |
|    1 |  2000 |
|    2 |  1800 |
|    2 |  2200 |
|    3 |  1700 |
+------+-------+
5 rows in set (0.00 sec)

Following is the query to sum rows with same id −

Example

mysql> select id,sum(price) as Total from demo84
   -> group by id
   -> having sum(demo84.price) >=2000;

This will produce the following output −

Output

+------+-------+
| id   | Total |
+------+-------+
|    1 |  4000 |
|    2 |  4000 |
+------+-------+
2 rows in set (0.00 sec)

AmitDiwan

Published on 11-Dec-2020 05:44:15

• Related Questions & Answers
• MySQL query to find the average of rows with the same ID
• MySQL query to sum rows having repeated corresponding Id
• Get rows that have common value from the same table with different id in MySQL
• Finding the sum of integers from multiple MySQL rows in same column?
• MySQL select * with distinct id?
• MySQL query to find sum of fields with same column value?
• MySQL query to merge rows if Id is the same and display the highest corresponding value from other columns
• Shifting values of rows in MySQL to change the existing id values for existing rows?
• Aggregating rows in SAP ABAP with the same name
• Count how many rows have the same value in MySQL?
• Delete more than one rows from a table using id in MySQL?
• MySQL query to find all rows where ID is divisible by 4?
• JavaScript Sum of two objects with same properties
• Count rows/columns with sum equals to diagonal sum in C++
• How to sum the score of students with the same name in MySQL with ORDER BY?