Mysql Adding values in a column based on values in other column

Question

Payment Table

What is the mysql query to get the below result from the table?. Addition in the amount column should be carried out based on the invoiceID.

enter image description here

Salil · Accepted Answer · 2012-09-25 11:04:41Z

1

SELECT @rownum := @rownum + 1 AS ID, InvoiceID, SUM(AMOUNT) 
FROM <tablename>, (SELECT @rownum := 0) r
GROUP BY InvoiceID

answered Sep 25, 2012 at 10:19

Salil

47.7k22 gold badges127 silver badges161 bronze badges

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

Comments

DevT · Accepted Answer · 2012-09-25 10:26:10Z

0

select ID,InvoiceID, SUM(Amount)
from <table>
group by InvoiceID

answered Sep 25, 2012 at 10:26

DevT

4,95316 gold badges63 silver badges95 bronze badges

Joe G Joseph · Accepted Answer · 2012-09-25 10:37:19Z

0

try this:

select  @i:=@i+1 AS id,a.*
     from
     (select InvoiceID,sum(Amount) as Amount
      from your_table
      group by InvoiceID)a,(SELECT @i:=0) r

answered Sep 25, 2012 at 10:21

Joe G Joseph

24.2k5 gold badges58 silver badges59 bronze badges