Results 1 to 2 of 2

Thread: Rownum

  1. 02-17-2010, 03:57 PM #1
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127

    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?
    Reply With Quote Reply With Quote
  2. 02-18-2010, 10:01 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Look for CONNECT BY statement in Oracle doc, you can specify PRIOR id to link to row before current one.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules