if you sum one field w/o a group by and if the sum of the fields taken seperatly and a group by statement added it gives different results
like ::
select sum(a*b ) from tabABC
and select sum(a) * sum(b) from tabABC
group by a,b
fetches different results.
why is that happening cd anybody explain