23 Nov 2010 ... SELECT key1, key2, SUM(ROUND(the_value)) AS total_value FROM the_table GROUP BY key1, ...
community.oracle.com