Fetch Data from MySQL based on specific set of dates

Question

i want to calculate the sum of the money i spent on the based on two specific dates, i have tried doing this using several queires but none of them seem to work. Below are the table and the query respectively,

     Product_ID----ProductName------price------OrderDate
    ---  1  --------  Chair -------- 7 ------ 2015-01-05
    ---  2  --------  Lamp --------- 14 ----- 2015-01-16
    ---  3  --------  Table -------- 9 ------ 2015-02-25

SELECT SUM(price) AS TotalPrice FROM orders
HAVING OrderDate >='2015-01-05' AND <= '2015-01-16'

juergen d · Accepted Answer · 2015-04-03 11:17:45Z

1

SELECT SUM(price) AS TotalPrice 
FROM orders
WHERE OrderDate >= '2015-01-05' AND OrderDate <= '2015-01-16'

or

SELECT SUM(price) AS TotalPrice 
FROM orders
WHERE OrderDate between '2015-01-05' AND '2015-01-16'

answered Apr 3, 2015 at 11:17

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sadikhasan · Accepted Answer · 2015-04-03 11:20:01Z

0

Change

HAVING OrderDate >='2015-01-05' AND <= '2015-01-16'

To

WHERE OrderDate >='2015-01-05' OrderDate AND <= '2015-01-16'

edited Apr 3, 2015 at 11:20

answered Apr 3, 2015 at 11:18

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

1 Comment

juergen d Over a year ago

having is actually rather for the use of group by

Collectives™ on Stack Overflow

Fetch Data from MySQL based on specific set of dates

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related