Can we retrieve all rows from a known OFFSET in HANA?

[Former Member]

select  * from "Product" LIMIT 20 OFFSET 20;

The above query returns 20 records after skipping the first 20.

Is it possible to fetch all the records after skipping the first 20?

[lbreddemann · Accepted solution]

There's no specific syntax for this.

But you can set a "real high" limit that would allow all remaining result rows to fit in.

[Former Member · Accepted solution]

Thanks Lars,

We also found an alternate solution to this as well. Putting it here in case anyone needs it.

Apart from setting a high limit, we can also modify the sql statement to

select  * from "Product" LIMIT null OFFSET 20;

This should also give the desired result.

[lbreddemann · Accepted solution]

If this is actually supported, it would be good to have it in the documentation.