看个例子:
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
150
2100
3 30
需要注意的是:10后面的小数点,确保18位精确。