No there is not. Two options could be to either create an UDF or use a programming language.
-----Original Message----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 5/25/04 1:25 PM Subject: is there a PRODUCT() or MULTIPLY() aggregate function? Is there an aggregate function that multiplies column values just like SUM() adds them? For instance, if "SELECT value FROM data" returns three values 2, 3, and 4, then "SELECT PRODUCT(value) FROM data" would return 24, which is 2 * 3 * 4. Thanks! --- Fyodor Golos Stockworm, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
