Results 1 to 2 of 2

Thread: Rownum

  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Rownum

    Hi All,

    I am trying to come up with the way of comparing a next record to the previous one using rownum but I am not sure how to do it. Any ideas?

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Read up on the LEAD and LAG functions for select. See the following link.

    ORACLE-BASE - LAG and LEAD Analytic Functions

    or search on google using

    oracle load lag
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •