[EMAIL PROTECTED] wrote:
I've got a query, let's say query "A" which returns data in the
following form:
price | count
3 5
3 8
4 2
4 9
4 12
6 10
What I want to do is get unique prices and sum the count of the
duplicates, so it gets
price | count
3 13
4 23
6 10
select price, sum(count)
from ... where ...
group by price;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
