Sample Header Ad - 728x90

Next 10% of rows

1 vote
1 answer
100 views
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