how to use offset in sql

[gangly]

I want to query data from snappydata using sql, like this:
select * from tableA limit 10, 20;
or
select * from tableA limit 20 offset 10;

and find error.

Does snappydata not support offset ?

[kneeraj]

Hi Gary - OFFSET is not supported yet. We plan to bring it in at some point soon though we can't give you an exact date now.

[TeslaCN]

“select * from (select row_number() over (order by id desc) rn, * from table) where rn between 1 and 10”
it works
李刚大佬好🌚

[jramnara]

this is likely quite expensive if the table is large. A better approach is to use monotonically_increasing_id() function to inject a id column into your table at load time. And, later use this to select the required range.

…

----- Jags SnappyData acquired by TIBCO <http://snappydata.io> Download binary, source <https://www.snappydata.io/download>

On Wed, Aug 28, 2019 at 12:28 AM 吴伟杰 ***@***.***> wrote: “select * from (select row_number() over (order by id desc) rn, * from table) where rn between 1 and 10” it works 李刚大佬好🌚 — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1369>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAOYUBVDUI7ZJ3JWYSP5EELQGYSIFANCNFSM4IGCQNIQ> .