Re: oracle rownum

On Aug 21, 9:52 am, odelya <be.spec..._at_gmail.com> wrote:
> Tha sort is not by the ID - it's by another parameter in the table
> (date..)

And how does the ID 'sequence' relate to the date by which these records are sorted? If it's anything like what you posted you'll have difficulty in returning a record plus the records immediately prior and immediately following the selected data as your IDs aren't in any discernable order -- the 'prior' record may have an ID greater than the 'reference' record, and the 'next' record may have an ID greater than the 'reference' but less than the ID for the 'prior'. We need better data, and a better definition of your 'problem' before we can proceed further. What you've provided so far is an over-simplified case which doesn't represent reality.

David Fitzjarrell Received on Tue Aug 21 2007 - 10:27:50 CDT