Below is my query
SELECT `months`,SUM(`price`) AS price
FROM `billing`
WHERE months='January' AND months='Feb'
I am trying to get result but this query is returning value NULL
Below is my query
SELECT `months`,SUM(`price`) AS price
FROM `billing`
WHERE months='January' AND months='Feb'
I am trying to get result but this query is returning value NULL
finally I got answer of my question
ans is:
SELECT months
,sum(price
) as price FROM billing
GROUP BY months