sumup distinct values

[habneh]

I want to sum up distinct values of a column how can I do that

ex

col1 col2
1 1
1 1
1 1
1 2
1 2
1 3

the result set should be

col1 col2
1 6

thanks

 

[onpnt]

do you mean
col1 col2
1 1
1 1
1 1
1 2
1 2
1 3

the result set should be

col1 col2
1 63



_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[kaht]

try this:

select col1, sum(col2) col2
(select distinct col1, col2 from tableName) a
group by col1

-kaht

Looking for a puppy?

http://www.silkypups.com

[small](Silky Terriers are hypoallergenic dogs that make great indoor pets due to their lack of shedding and small size)[/small]

 

[onpnt]

derr..thinking count()

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[onpnt]

This one works well (in 2005)

select 
col1,
sum(distinct col2)  
from @tbl
group by col1

pretty much the same as kahts though

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[kaht]

Nah, yours is 1 select statement, mine's 2

-kaht

Looking for a puppy?

http://www.silkypups.com

[small](Silky Terriers are hypoallergenic dogs that make great indoor pets due to their lack of shedding and small size)[/small]