To select Nth record in the table

[former_member201560]

Dear all,

I have requirement in HANA SQL stored procedure to select the Nth record from the table. The number "N" is derived based on some conditions in the SQL.

Could you please help in framing out the query.

Regards,

Yogesh

[former_member182114 · Accepted solution]

Hi Yogesh,

The best option to solve your question seems to be OFFSET and LIMIT from SELECT statment.

SELECT - SQL Reference - SAP Library

Inside your procedure you can find the Nth number you want and use it as offset with -1. If you only wat one row so LIMIT to 1, or obtain how many you want later.

Regards, Fernando Da Rós

[former_member201560 · Accepted solution]

Hi Fernando,

Thanks for your help. I tried with your approach. It works for me.

Regards,

Yogesh

[former_member182302]

You can use row number . I guess you might have already checked this thread:

Do we have a ROWID or equivalent in HANA ? | SAP HANA

Regards,

Krishna Tangudu