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'
The result(vwap and sumprice) I get for the above(single symbol) is
different from when I use multiple symbols:
'where symbol in('XYZ', 'ABC') GROUP BY symbol'
The above happens only for those symbols which has more ticks within the
time range. Is this an issue of intermediate results on aggregate function?
Please help.
BR
--
View this message in context:
http://firebird.1100200.n4.nabble.com/Difference-in-result-when-GROUP-BY-is-used-tp4637547.html
Sent from the firebird-devel mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
