How to alternately select m rows every n rows in oracle sql

Leave a Comment / Systems / By

For m=10 and n=100 add the following where clause

WHERE MOD(rownum, 100)<10

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.