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?
Printable View
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.