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 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 Is there any function like that in mysql?? I know I can do this with stored procedure.. But I'm using 4.1.3 Please help.... TIA -- Leonardus Setiabudi IT Department PT Bina San Prima Jl Tamansari 10-12 022-4207725 #316 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
