Sum , count eller hvad?

Jeg håber at det er ok på engelsk, regner at alle her kan forstå det ellers giv lyd.


Hi guys, big problem.

I need to find a sum/quantity, and i am completely lost.

Here is the senario:

I have some records where i need to select the ones with the same productid ontop of that i need to get a the sum of numbers in a field called quantity.

Plus jeg behøver at finder en samlet pris udra antallet af ovenstående, man må kunne beregne det i transact sql på en måde ex.. totalsales = (totalquantity*price) eller så noget lignede.


I have made an image so you can see.

http://www.pcl.dk/sel.gif