I am facing a problem when writing HANA Procedures.
I am trying to use the SQL window function LEAD / LAG and PARTITION functions. But I am getting syntax errors on the same.
The same code ran successfully when I wrote in AMDP methods.
I believe the NATIVE SQL syntax should be same in AMDP or HANA Procedures. The code is given below. Please let me know where the things going wrong.
Below is the code -