Categories Systems How to alternately select m rows every n rows in oracle sql Post author By kostas Post date October 7, 2011 No Comments on How to alternately select m rows every n rows in oracle sql For m=10 and n=100 add the following where clause WHERE MOD(rownum, 100)<10WHERE mod(rownum, 100)<10 ← Check if shared library is installed on Mac OS X → Select rows based on date in Oracle database Leave a Reply Cancel replyYou must be logged in to post a comment. This site uses Akismet to reduce spam. Learn how your comment data is processed.