Thx , you're right. But in this case this isn't the prob...
As I described I need the sum of each single day of all days per month.
I guess I need something like DISTINCT, JOIN and SUM..but I don't know how 😞
Hi,
I want to summarise my monthly sales results per day (see Attachment).
That's my current code:
SELECT sum FROM tb WHERE year=selected_year AND month=selected_month ORDER BY day ASC
But instead of showing each single sale I want to summarise all sales per day and show the total sum.
How can I do this?
THX
Simon