CODEWITHSUNDEEP
questdb
funnymay
funnymay

Reputation: 391

How to skip N rows in QuestDB SQL?

I'm creating paging output from data in QuestDB table and want to take 100 rows after X pages of 100 rows. In Postgres it would be something like

select * from tbl
OFFSET 200
LIMIT 100

I see LIMIT but cannot find OFFSET equivalent in QuestDB SQL, is it supported?

Upvotes: 1

Views: 165

Answers (1)

funnymay
funnymay

Reputation: 391

Thanks to @basha04 the equivalent query is

select * from tbl
LIMIT 200,300

Upvotes: 1

Related Questions