看个例子:
CREATE TABLE #tmp (RowID INT, RowValue INT);
INSERT #tmp( RowID, RowValue ) VALUES ( 1, 10);
INSERT #tmp( RowID, RowValue ) VALUES ( 1, 5);
INSERT #tmp( RowID, RowValue ) VALUES ( 2, 20);
INSERT #tmp( RowID, RowValue ) VALUES ( 2, 5);
INSERT #tmp( RowID, RowValue ) VALUES ( 3, 30);
SELECT * FROM #tmp;
SELECT RowID, POWER(10.,SUM(LOG10(RowValue))) AS PRODUCT
FROM #tmp t
GROUP BY RowID;
返回结果:
RowID PRODUCT
1 50
2 100
3 30
需要注意的是:10后面的小数点,确保18位精确。