Geek asks and answers

Mysql query to find the sum of fields with the same column value

I have a table like this

id |  invent_id         |   order
 1 | 95948214           | 70
 2 | 46018572           | 30
 3 | 46018572           | 20
 4 | 46018572           | 50
 5 | 36025764           | 60
 6 | 36025764           | 70
 7 | 95948214           | 80
 8 | 95948214           | 90

I want to get the sum of qty order with the same id id

This is what you need for the result.

   |  invent_id         |   order
   | 95948214           | 240
   | 46018572           | 100
   | 36025764           | 130

how can we write mysql query

+5
source share
1 answer

Use the Aggregate function SUMand group them according to invent_id.

SELECT invent_id, SUM(`order`) `Order`
FROM tableName
GROUP BY invent_ID

GROUP BY clause

SQLFiddle Demo

+13
source

More articles:


All Articles