Using Distinct and SUM in query problem

smitty912 · #1 (**permalink**) 06-11-09, 13:28

Hi,

I tried the following query and it doesn't work. The 'created' field is in datetime.

select distinct month(created) as created,
sum(cost) as total_cost
from finances
group by created;

I want to display the total cost incurred for each unique month. A simple request yet its confusing to make it work.

Please help

Regards,
wayne

Ax238 · #2 (**permalink**) 06-11-09, 13:45

Try this instead:

Code:

select month(created) as created,
sum(cost) as total_cost
from finances
group by month(created);

Regards,

Ax

smitty912 · #3 (**permalink**) 06-11-09, 14:03

Quote:

Originally Posted by Ax238

Try this instead:

Code:

select month(created) as created,
sum(cost) as total_cost
from finances
group by month(created);

Regards,

Ax

Cheers Ax

, thank you so much! It works now, i just spend a whole day figuring it out..damn i'm a noob

Ax238 · #4 (**permalink**) 06-11-09, 14:37

Great to hear! No worries, easy mistake.

Internet Services

Web Development

Digital Marketing

Consumer Tech