Subject | aggregate product() or equivalent |
---|---|
Author | unordained |
Post date | 2005-02-03T23:56:14Z |
Is there an aggregate function that multiplies all non-null values to provide a result? If not, is
it possible to write aggregate functions as UDF's? (Does anyone have any examples?) This would be
to use in a select with group-by, to find total ratios for several items at once, based on the
product of component ratios.
-Philip
it possible to write aggregate functions as UDF's? (Does anyone have any examples?) This would be
to use in a select with group-by, to find total ratios for several items at once, based on the
product of component ratios.
-Philip