We can use SELECT * FROM tab WHERE rownum<=N ORDER BY to get the top n rows.
How can I get the rows from M to N, that is, skip M rows then get top N?
We can not use condition like rownum>=M as it is always FALSE.
Thanks for any help.
Results 1 to 2 of 2
Thread: Skip-M Top-N
Click Here to Expand Forum to Full Width