MozillaZine

Findind cumulative amounts through SQL query on web develop?

Discuss how to use and promote Web standards with the Mozilla Gecko engine.
kokilasoral
New Member
 
Posts: 1
Joined: June 1st, 2016, 11:19 pm

Post Posted June 2nd, 2016, 2:02 am

stressed with a SQL query I have a gathering process and I need to have a query that display me each day how far we have gathered so far through the current month in a increasing way. I have all the info in one table named Prodo the date field is Process Date and the amount is in l_camnt Field.
So far I have this:
Query:
SELECT
Prodo.ProcessDate, SUM(Procesado.l_camnt) AS Monto
FROM
Prodo
WHERE
Prodo.ProcessDate >= Procesado.ProcessDate
GROUP BY
Prodo.ProcessDate
Table value
Table Name: Procesado
Process_Date l_camnt
05/26/2015 $1000
05/26/2015 $500
05/27/2015 $2000
05/27/2015 $1000
05/28/2015 $5000
Desired output
05/26/2015 $1500
05/27/2015 $4500
05/28/2015 $9500

Pim

User avatar
 
Posts: 2205
Joined: May 17th, 2004, 2:04 pm
Location: Netherlands

Post Posted June 12th, 2016, 11:24 am

This is not quite the kind of forum to ask that kind of questions. For one thing, I don't see how this has anything to do with web development. And for another, I don't see a question.
Groetjes, Pim

Return to Web Development / Standards Evangelism


Who is online

Users browsing this forum: No registered users and 2 guests