0
Well I have a select that returns the total order amount made in the current week. I do it as follows:
SELECT
SUM(valor)
FROM
pedidos
WHERE
YEARWEEK(data) = YEARWEEK(NOW())
Well I need a select for each day of the week, that returns me the total of each day of the current week.
How can I do that?
It worked, he returned me the days in numbers. It would be 0 for Sunday and 6 for Saturday?
– Hugo Borges
Yeah, that’s right, that’s right
– Bins
Thank you very much.
– Hugo Borges