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?