Row comparison
Posted: Tue Feb 08, 2011 1:29 am
Hi All,
I have input data as below:
SESSION ID PAGE NUMBER PAGE_NAME
123 1 akajak
123 3 lkuibgt
123 7 opgyt
567 1 hagdljkh
890 1 haklik
890 4 kuioud
890 7 jhkljkl
I need to implement "IF next record is the same Session_ID, then take Page_Number from the next record, subtract 1 from this Page_Number else some other logic.
Could anyone suggest me how can i implement this logic.
Please let me know if need anymore clarification?
Thanks & regards,
Kalpana.
I have input data as below:
SESSION ID PAGE NUMBER PAGE_NAME
123 1 akajak
123 3 lkuibgt
123 7 opgyt
567 1 hagdljkh
890 1 haklik
890 4 kuioud
890 7 jhkljkl
I need to implement "IF next record is the same Session_ID, then take Page_Number from the next record, subtract 1 from this Page_Number else some other logic.
Could anyone suggest me how can i implement this logic.
Please let me know if need anymore clarification?
Thanks & regards,
Kalpana.