There is no direct way to multiply all the values of a column as we do summation using SUM(col). But it is possible with the following methods create table test ( i int , amount float ) insert into test ( i , amount ) select abs ( cast ( cast ( newid...