Hi Nam, Can you please properly subscribe to the mailing list so that the community receives email notifications? Here is the instruction: http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1
Nam Nguyen wrote > In my case, I want to load the data by paging. But I cannot found any > solution? > > For example: I have 100000 rows in result of query, but I only want to get > rows between 70000 to 80000. You can use 'LIMIT ... OFFSET ...' clause for this. In your example the query should look like this: SELECT ... LIMIT 10000 OFFSET 70000 Let me know if this works for you. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-filter-result-of-query-by-row-number-tp3621p3624.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
