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')
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