Thanks, that speeded things up a bit (2.5x)! :)
On Wed, 30 Jan 2002, Zabach, Elke wrote: > Dag �yvind Liodden wrote > > > > > > > > What is the best way to do this? Any ideas? > > > > > > one idea (don't ask if this is the best): > > > > > > select symbol, change, price, trade_time, volume > > > from trade t1 > > > where (trade_id,symbol) = (select max(trade_id),symbol > > > from trade t2 > > > group by symbol) > > > > > > The you do NOT have a correlation > > > > This gives me an error: "More than one result row not allowed". > > > > Sorry, change to > ...symbol) = any (select > > Elke > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
