Lead function

[Neha11]

Hi everyone, 

I want to compare current row with all the other rows in the table

I have used lead function in case statement, 

But while setting an offset value it only takes a certain number , like lead(col name,2) , but I want the offset to be in certain range, becos I need to compare current row with all the other rows in tge table

Is there any way to achieve this?

Thanks & Regards,

Sonam Mathur 

[#2]

That's to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.