DWQA QuestionsCategory: DatabaseHow to paginate query results in dolphin DB
Davis asked 4 weeks ago

How to paginate the query results in dolphin dB, for example, I want to get the 50 to 100 records of a table? For example, select * from table limit 50100 in MySQL

1 Answers
wale answered 4 weeks ago

Lines 50 to 100 can be used

select top 50:100 * from table

The first 100 lines can be used

select top 100 * from table