The below example shows how to find the product of values in one column of table
declare @values table (value float)
declare @product float
insert into @values values (1)
insert into @values values (-3)
insert into @values values (2)
insert into @values values (6)
set @product = 0
select @product = exp(sum(log(abs(value)))) from @values
if ((select count (1) from @values where value < 0) % 2) =1
begin
select @product = @product * (-1)
end
select @product
No comments:
Post a Comment