Re: "PRODUCT()" function - calculating the product of grouped numeric values

2004-08-31 Thread Thomas Schager
Hi, > you might take a look at this thread: > http://lists.mysql.com/mysql/166184 Thanks a lot - perfect. I was searching for a mathematical function too, but I didn't cope it... this version works great! Best regards, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql

Re: "PRODUCT()" function - calculating the product of grouped numeric values

2004-08-31 Thread Johan Hook
Hi, you might take a look at this thread: http://lists.mysql.com/mysql/166184 /Johan Hi, I'm searching for a function that enables me to calculate the product of a group of values, like SUM() does. MySQL server version is at least 4.0.14. For example, a query like "SELECT id, PRODUCT(value) AS 'pr