How to multiply the values in a column of table in SQL

Question

I want to multiply the values in ID column of mytable :

I am using the SQL query as below:

SELECT EXP(SUM(LOG(ID))) as result 
from dbo.mytable with (nolock)

Any other ways to calculate the multiplication of ID values, Please share.

may be you are looking for this one http://stackoverflow.com/questions/28409884/how-to-find-running-multiplication — mohan111, Nov 24 '16 at 05:29
What's wrong with the method you have? There's not a built-in multiplication aggregator. — D Stanley, Nov 24 '16 at 05:30

score 0 · Answer 1 · answered Nov 24 '16 at 05:31

0

You can do It simply by declaring an variable

DECLARE @MulVal INT SELECT @MulVal = Id * COALESCE(@MulVal, 1) FROM #Tbl SELECT @MulVal

answered Nov 24 '16 at 05:31

Mansoor

1 Answers1