sum and distinct query 1

[ietprofessional]

Here is the table I'm working with and what I'd like to pull out of it. I hope you can help.

Initial Table:

product    units
product1     2
product1     1
product1     3
product2     4
product3     3
product3     5

What I'd like to pull:

product1     6
product2     4
product3     8

Thanks for all your help!

 

[PHV]

A simple aggregate query:
SELECT product, Sum(units) AS total
FROM yourTable
GROUP BY product;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

Hi

Select Product, Sum(Units)
From MyTabel
Group By Product

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[ietprofessional]

Sorry SkipVought, PHV beat you to the point.

TNX!

 

[SkipVought]

Yea, I know! ;-)

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}