I know TOP can return first 10% of row results, but how would I then get the next 10%?
I am trying to break up a query that crashes due to insufficient memory (java.lang.OutOfMemoryError), and want to return the first 10% of results, then edit it so it returns the next 10%, and so on.
I am using SQL Anywhere 12.
Asked by KAE
(143 rep)
Apr 6, 2020, 04:15 PM
Last activity: Apr 6, 2020, 06:26 PM
Last activity: Apr 6, 2020, 06:26 PM