How to alternately select m rows every n rows in oracle sql October 7, 2011February 20, 2013kostas For m=10 and n=100 add the following where clause WHERE MOD(rownum, 100)<10WHERE mod(rownum, 100)<10