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

WHERE MOD(rownum, 100)<10 |

Skip to content
# How to alternately select m rows every n rows in oracle sql

trying stuff with code

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

WHERE MOD(rownum, 100)<10 |