CODEWITHSUNDEEP
mysqlsql
user1715025
user1715025

Reputation: 53

sql previous week total

Looking for a query to total previous week

Current day

SELECT Sum(total_cost)AS "total" 
FROM   purchases 
WHERE  datetime >= Curdate();

Current Week

SELECT SUM(total_cost)as "total" 
FROM purchases 
WHERE datetime >= DATE_SUB(CURDATE(), INTERVAL 1 WEEK);

Previous day

SELECT SUM(total_cost)AS "total"
FROM purchases
WHERE datetime >= DATE_SUB(CURDATE(), INTERVAL 1 DAY)
  AND datetime <= CURDATE();

Looking for query similar to this for calculating previous week. Can't seem to get it working.

Upvotes: 1

Views: 225

Answers (2)

Mahesh Sambu
Mahesh Sambu

Reputation: 349

select SELECT SUM(total_cost) AS "total"
  FROM purchases
  WHERE datetime between dateadd(d,-14,CURDATE()) and dateadd(d,-7,CURDATE())

Upvotes: 0

Rahul Tripathi
Rahul Tripathi

Reputation: 172398

May be you want this:-

SELECT SUM(total_cost)AS "total"
    FROM purchases
`datetime ` >= DATE_SUB(NOW(),INTERVAL 14 DAY) 
AND `datetime ` < DATE_SUB(NOW(),INTERVAL 7 DAY)

Upvotes: 1

Related Questions