How to Group and Sum rows with matching column

[jase2006]

Hi, currently trying to group all the rows with a column containing matching dates and sum all the rest of the columns together. Can anyone suggest a good SQL sample to do this. The Data looks like this:

Currently:
24/08/07 7 1 2 2
24/08/07 8 2 1 1
21/08/07 3 2 1 1

I want:
24/08/07 15 3 3 3 <- grouped and summed
21/08/07 3 2 1 1

 

[r937]

select foodate
     , sum(foocol1) as total_col1
     , sum(foocol2) as total_col2
     , ...
  from daTable
group
    by foodate

r937.com | rudy.ca

 

[jase2006]

Thanks r937!