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 'product' FROM table GROUP BY id" for this table
-- Johan Höök, Pythagoras Engineering Group - MailTo:[EMAIL PROTECTED] - http://www.pythagoras.se Pythagoras AB, Stormbyv. 2-4, SE-163 55 SPÅNGA, Sweden Phone: +46 8 760 00 10 Fax: +46 8 761 22 77
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]