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?
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
Forum Rules