Answer the question
In order to leave comments, you need to log in
Answer the question
In order to leave comments, you need to log in
It seems that in no way, make an infinite grid with loading the next portion of the cursor replacing the classic pagination.
Well, or add to all requests:
SELECT * FROM (
SELECT COUNT(*) OVER() as cnt, ROW_NUMBER() OVER(ORDER BY ...) as rn, ....
)
WHERE rn BETWEEN :ST AND :ED
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question