Hello ALL,

I am new to this forum and would like to ask of any person who can assist me in this problem.

I currently have a table with 3 rows like this:

Pid Counter P_cprice
19 3 49.5
16 5 143.5
16 2 143.5

I am trying to retrieve the following data:

19 3 49.5
16 7 143.5

I have tried many ways but am going nuts over this. It looks simple but I have no clue. Is there anyone who can help me?

Kevin.

select pid,sum(counter),p_cprice
from table_name
group by pid,p_cprice

hmm...now why didn't i think of that? thanks a whole lot!