You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by vkulichenko <va...@gmail.com> on 2016/03/22 20:38:05 UTC

Re: How to filter result of query by row number?

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.