CODEWITHSUNDEEP
mysql
Uma
Uma

Reputation: 239

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

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

Upvotes: 0

Views: 45

Answers (3)

Salil
Salil

Reputation: 47492

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

Upvotes: 1

Joe G Joseph
Joe G Joseph

Reputation: 24076

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


SQL Fiddel demo

Upvotes: 0

DevT
DevT

Reputation: 4933

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

Upvotes: 0

Related Questions