Re: selecting _only_ the latest ten items

From: Norris <johnnie_at_cooper.com.hk>
Date: 8 Sep 1999 09:59:56 GMT
Message-ID: <7r5c2s$13u0$1@adenine.netfront.net>

Using PL/SQL is faster!?

In comp.databases.oracle.misc Jan Rosinowski <spamfilter_at_rosinowski.de> wrote:

>>select * from toppers a
>>where 2 > (select count(*) from toppers b
>>                   where b.dt < a.dt );

> prolog style :-) alas ora isn't optimising this stuff efficiently

> ciao, jan

> dokumentenmanagement und mehr: http://www.rsp.de/ vertriebspartner gesucht!

--
Have several nice days...

---

Opinions are mine and do not necessarily reflect those of the Corp.

http://www.ntfaq.com

http://www.jsiinc.com/reghack.htm

http://www.oconnell.net/Sybase_FAQ

http://www.cyberport.com/~tangent/programming/winsock/

===================================================================

Received on Wed Sep 08 1999 - 04:59:56 CDT