aggregate functions for the product of elements
Posted on 1998-08-28
I've a problem with aggregate functions. Is there similar to SUM an other function that results in the product the element.
SELECT name, sum(value) FROM Table GROUP BY name
name sum of value
I'm looking for a function that will result in
name prduct of value
a 6 (i.e. 2 * 3)
b 12 (i.e. 3 * 4)
Is there a function for it? or do I've to do it with cursors and other programming techniques?
I'm quite desperate for the answer.
Oh, and there is no other way to organise the tables, so please don't give plain suggestions in that direction.
The database calculates the price of elements. This price consists of the product of varying attributes which are in a child table.
Any help will be highly regarded,