Thank you so much for your help,

I wanted to avoid self join , was looking for lead, lag function like in oracle.

😀