Instead of SUM() I require MULTIPLY

From: Ethan Post <post.ethan_at_gmail.com>
Date: Fri, 9 Dec 2005 16:13:09 -0600
Message-ID: <357b48a90512091413x3471adc5w463f25d45f2dc75d@mail.gmail.com>

I just came up with a function I would like, but don't think exists.

TABLE TEST (X NUMBER)

---

2
2
4

select sum(x) from test;

will return 8...

what I need is

select multiply(x) from test;

will return 16, because 2*2*4 is 16.

Anyone ever seen a SQL aggregate function like this? I don't think it exists but I hold out hope.

• Ethan

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 09 2005 - 16:13:24 CST