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

[phil_soady]

From 7.52 Select from x

up to n rows

offset skip_rows

where (cond)

order by....

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abapselect_up_to_offset.htm

[s_kulkarni]

Hi Phil,

This really helped.