Question:
Is it possible to somehow organize the possibility of displaying the part of the query from n to m positions as it is implemented in MySQL by adding limit n,m to the query?
There is a solution to wrap in several queries, but not suitable due to the load on the database with such queries for "medium-large" tables:
select * from (select rownum as rn,* from ... where ...) d where d.rn between n and m
And the scan shows that the entire subquery is stored in memory.
Is it possible somehow to substitute n and m in the first query (nested)?
Answer:
Hi guys from 2011, I'm in 2015 now and we do this:
SELECT * FROM my_table
OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY;