im suck on a query, and cant seem to get arround a mind block.

i have a list

col1 col2
112233 12
112233 13
112233 54
221144 1
221144 10

i need to get the sum of the values in col2 for each distinct value in col1, so for the col1 value of 112233 the col2 sum would be 79 since 12+13+54 = 79

SELECT SUM(col2)
FROM myTable
Group By col1

thanks... doh..

try this:
select col1,sum(col2)
from <table>
group by col1