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

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle rownum

Re: oracle rownum

From: Wiktor Moskwa <wiktorDOTmoskwa_at_gmail.com>
Date: Tue, 21 Aug 2007 15:38:31 +0000 (UTC)
Message-ID: <faf0tn$55a$1@nemesis.news.tpi.pl> 





On 21.08.2007, odelya <be.special_at_gmail.com> wrote:


>

> Tha sort is not by the ID - it's by another parameter in the table

> (date..)

>




LEAD and LAG analytic functions will be your friends.


-- 
Wiktor Moskwa


Received on Tue Aug 21 2007 - 10:38:31 CDT












Original text of this message













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