I want to multiply column values within a table using an aggregate function in MYSQL similar to sum(column1) or avg(column1).
I have tried product(column1) but the product function does not work.
Kindly assist.
>Solution :
If all your values are integers greater than zero, you can do:
round(exp(sum(log(column1))))