Skip to Content
0
Jul 09, 2015 at 09:28 AM

SQL window functions in HANA procedures

97 Views

Hello

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 -

Attachments

Capture.JPG (45.3 kB)