Hey @MichaelBBTiger thanks for the report - I just opened an issue: Allow LIMIT before OFFSET per the documented grammar · Issue #3531 · xtdb/xtdb · GitHub
As a workaround for now you can at least write the OFFSET before the LIMIT without errors: XTDB Play
If I write the OFFSET before the LITMMIT，modify the value of offset has no change in the result.
Ah, my apologies - I should have confirmed the specific behaviour. I agree OFFSET is not working at all and have updated the issue accordingly. We will get this fixed soon.
In the meantime though please do message to tell us if you are blocked at all - always happy to chat: hello@xtdb.com
1 Like
Hey @MichaelBBTiger, thanks for the bug report 
I’ve just pushed a fix for this and a change to the docs, both of which will be deployed with our next snapshot release.
Cheers,
James
1 Like