How to alternately select m rows every n rows in oracle sql Leave a Comment / Systems / By kostas For m=10 and n=100 add the following where clause WHERE mod(rownum, 100)<10