darktaiga01 opened a new issue, #8770: URL: https://github.com/apache/pinot/issues/8770
I have some problem about using LIMIT clause for paginating. I query this statement `select * from baseballStats order by yearID desc limit 0, 20` It returns first 20 rows of the result. And it's fine. But when I want to query this statement `select * from baseballStats order by yearID desc limit 200,300`  It return first 300 rows of the result (0 to 300) but I want it return from offset 200 to 300 I've tried some statement as following `select * from baseballStats order by yearID desc limit 87000,88000`  And it return 10889 rows (from offset 87000 to 97889 and 97889 is number of rows in my table) Did I use it incorrectly, or is this feature not working as I understand? Thanks for reading. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
