I'm trying to use the previous value from a row to perform some calculation on the present row. On SQL we have the LAG and LEAD functions that let you use the previous and the next value. What do we have in the ICM SQL?
Printable View
I'm trying to use the previous value from a row to perform some calculation on the present row. On SQL we have the LAG and LEAD functions that let you use the previous and the next value. What do we have in the ICM SQL?
Hi there, could you please provide more details (e.g., what table) about what you like to do?