Re: Function to multiply multiple row values

2004-08-22 Thread Leonardus Setiabudi
> > x > > --- > > 1 > > 2 > > 3 > > 4 > > > > Select sum(x) would return 10 right.. > > > > Now I need a function .. Say fx() so that when I issued > > > > Select fx(x) ... > > It would return 24 which is 1x2x3x4 > > > I assume that the function that yielded 24 was fx(4), not fx(x). In high > s

Re: Function to multiply multiple row values

2004-08-22 Thread Rhino
- Original Message - From: "Leonardus Setiabudi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 22, 2004 11:45 PM Subject: Function to multiply multiple row values > Hi All, > > Can someone point me a function that return the multipli

Function to multiply multiple row values

2004-08-22 Thread Leonardus Setiabudi
Hi All, Can someone point me a function that return the multiplication of query result.. Hack.. It's hard for me just to explain what I nedd.. Ok, it goes like the sum() function, but instead of the summary.. It will return the multiplication Here is what I need it to do x --- 1 2 3 4 Selec