You are here

How to select records with given interval

How to select records with every N records' interval?
Using the rank(), this is the the snipet, for Oracle:
Table name: tableabc,
---------------------
id  |  time  |   test
---------------------
SELECT id, rank() over (partition by 1 order by time) as interval, test
                                   FROM  tableabc 
                                   WHERE mod (interval, N) = 0;
 
N is the given interval