Hi All

I have just got my head around simple calculation in SQL.... What I need to acheive now though is to be able to select several rows that using a WHERE clause and then perform a calculation on the selected rows e.g.

SELECT FIELD1 FROM PRODUCTS WHERE PRODUCTTYPE = 1 - Thats the easy bit!

Now I need to add all of the selected rows together.

Is there syntax to do this?

Ta

Rit

__________________
Rit
www.designandonline.co.uk
INSPIRE | CREATE | DELIVER

I suggest you look at Aggregate Functions in SQL Books Online.
Something like:
--

Joe (Microsoft MVP - XML)

Thanks Joe, I Found something exactly on those lines.

Rit

Please post your solution so we can all learn.

Thanks,
Richard

Sure no problem..

SELECT SUM(Field1) FROM PRODUCTS WHERE PRODUCTTYPE = 1 GROUP BY PRODUCTTYPE)

What I needed to do was isolate a particular selection .. in this example the PRODUCTTYPE = 1 so I dropped in a WHERE clause followed by the GROUP BY.

Seemed to work great... if anyone can see a betetr way then we are all up for learning.

Warm Regards

Rit

Sweet. Thanks for the solution post.

no problem.