Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: selecting _only_ the latest ten items

Re: selecting _only_ the latest ten items

From: Jan Rosinowski <spamfilter_at_rosinowski.de>
Date: Wed, 08 Sep 1999 08:40:00 GMT
Message-ID: <37d6048e.2275341@160.45.4.4> 





>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!
Received on Wed Sep 08 1999 - 03:40:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US