select rows start at a specified index using OPEN SQL

[former_member269903]

Hi all,

If I want to select 1st~100th entries in database, OPEN SQL has a term 'UP TO 100 ROWS' to do it.

But I can not find a quickly way to select 100th~200th entries in database. Is there any method in open SQL, to let me select  entries start at a specified index?

I need to support this features in SAP GATEWAY backend. Hope someone can tell me how to do it, thanks.

Regards

Dongqiang

[sundaramoorthy_ramalingam]

This message was moderated.