Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> MULT() instead of SUM()
Hi,
I'm Chris from France.
I would like to simulate an aggregate function which multiply instead
off add.
I would like to use it in query
A function like SUM() which could be called MULT()
SELECT NAME, MULT(QTY)
FROM TABLE
GROUP BY NAME
Give me the result QTY * QTY * .... * QTY for each name.
Is it possible and how can I do this.
Thank you for your help.
Christophe... Received on Thu Nov 16 2000 - 09:34:05 CST