> > SELECT id, MUL(val) FROM above_table GROUP BY id; > > I would get: > +----+-----------+ > | id| MUL(val)| > +----+-----------+ > | 1| 200| > | 2| 250| > +----+-----------+ > > ****************** > I know there is now function MUL(), but is there anything comparable ? > Nope, you have to write your own UDF.
sql, table -- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php