Mysql sum up rows and columns

Question

This is kinda hard to explain so I'll do this step by step. Below is the table i've created.

id  | item_1 | item_2 | item_3|
32  |   1    |   43   |  54   |
32  |   54   |   32   |  32   |
67  |   42   |   45   |  12   |

As you can see, the first 2 rows has the same id, my goal is, get the sum of the first row which is (1+43+54), and the sum of second row which is (54+32+32), then add both rows with the same ID's and sort them up from highest to lowest. Can someone help me with this?

sum of the first row which is (1+42+54)? it should be (1+43+54), right? — sarwar026
– sarwar026, Commented Jul 7, 2013 at 4:10

Orangepill · Accepted Answer · 2013-07-07 04:12:24Z

6

I think what you are looking for is

 select 
      id, 
      sum(item_1+item_2+item_3) as item_sum 
 from yourtable 
 group by id 
 order by item_sum desc;

answered Jul 7, 2013 at 4:12

Orangepill

24.7k3 gold badges44 silver badges64 bronze badges

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

1 Comment

user2310422 Over a year ago

This solved my problem, thanks! I'll mark your answer correct in 7 min

Vikdor · Accepted Answer · 2013-07-07 04:19:47Z

4

I would do it as follows:

SELECT 
    ID, 
    SUM(Total) as TotalSum
FROM 
    (
        SELECT ID, ITEM_1 + ITEM_2 + ITEM_3 as Total 
        FROM 
            MyTable
    )
GROUP BY ID
ORDER BY TotalSum DESC

edited Jul 7, 2013 at 4:19

answered Jul 7, 2013 at 4:11

Vikdor

24.2k10 gold badges66 silver badges86 bronze badges

Collectives™ on Stack Overflow

Mysql sum up rows and columns

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