Re: [Firebird-devel] Difference in result when GROUP BY is used

2014-09-08 Thread Leyne, Sean
Matt, > I am have a query to perform aggregation functions on data retrieved from > FB. This result differs when using GROUP BY. Query looks something like: > > 'select > symbol, > sum(price * vol)/sum(vol) as VWAP, > sum(price) as SUMPRICE > > from Table1 > where symbol in('XYZ')

[Firebird-devel] Difference in result when GROUP BY is used

2014-09-06 Thread Matt
Hi, I am have a query to perform aggregation functions on data retrieved from FB. This result differs when using GROUP BY. Query looks something like: 'select symbol, sum(price * vol)/sum(vol) as VWAP, sum(price) as SUMPRICE from Table1 where symbol in('XYZ') GROUP BY symbol' T