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
