How can I find product of a column in SQL? Is there any aggregate function available for this?
If I want to get the sum of the column salary from table emp, this will do
select sum(salary) from emp
What if I want to get the product of all salaries from emp table?
Any pointer will be greatly appreciated.
If I want to get the sum of the column salary from table emp, this will do
select sum(salary) from emp
What if I want to get the product of all salaries from emp table?
Any pointer will be greatly appreciated.