Re: SQL Aggregate Function

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 4 Dec 1999 20:06:01 -0000
Message-ID: <944338082.10775.0.nnrp-02.9e984b29@news.demon.co.uk>

select colX, exp(sum(ln(colY)))
from tableT
group by colX

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

stefanie.kaletsch wrote in message <82bq1l$cda$1_at_news00.btx.dtag.de>...
>I'm looking for a aggregate function for multiplication (similar to sum()).
>Is there anybody who know a oracle function or a workaround.
>
>Thanks for any suggestion,
>Stefanie
>
>
Received on Sat Dec 04 1999 - 14:06:01 CST