KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I would like to calculate total order amount in the previous month. I got the query for getting the data for the present month from the current date. SELECT SUM(goods_total) AS Total_Amount FROM orders WHERE order_placed_date >= date_sub(current_date, INTERVAL 1 MONTH); Now how can I get Previous Months Data only, excluding this month. For e.g. This month (July) I made $15,000 and last Month(June) i made $14,000. I get the $15,000 by running the above query. But i dont know how to calculate Previous Months.
Tags (comma-separated)
Save Edits
Cancel