Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> MULT() instead of SUM()

MULT() instead of SUM()

From: gaussent <gaussent_at_dase.bruyeres.cea.fr>
Date: Thu, 16 Nov 2000 16:34:05 +0100
Message-ID: <3A13FE6D.9B75CEA5@dase.bruyeres.cea.fr>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US