Lead function

Copper Contributor

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 

 

 

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