Multiplying values from different rows

[Pettor]

Hello all,


I am now learning SQL and I have one question. I would like to retrieve the last row's data from the table above it.
Meaning that I would like to group the data based on the number 10248, receiving the product of the three numbers of the table rows (11*42*72).
Probably for someone else this should be super easy but I don't know the methodology to do something like that.
Every help is much appreciated. Thanks!


A B C


1 10248 11
2 10248 42
3 10248 72




10248 3 33264

 

[63falcondude]

vba log function (used in MSAccess, and unlike the Excel Log() function) returns natural log so that's why it works.

vba: exp((log(11)+log(42)+log(72)))
excel: 10^(log(11)+log(42)+log(72))
excel: exp(ln(11)+ln(42)+ln(72))

all give answer the same answer of 33264

yikes

Okay, that explains it then. VBA (and SQL apparently) log function uses base e whereas Excel log function uses base 10. What a pain in the butt.

Interesting, but a pain.