SELECT A, SUM(B*C) FROM test GROUP BY A Output: 10011 444.0000 10012 153.8500 10014 422.7700 10015 34.9700 10018 70.4400