While the previous suggestion will work for ANY SELECT query, if you are really only interested in the rows of a single table, and the table is a normal table (not a WITHOUT ROW_ID), then this would suffice: ~~~ SELECT * FROM t WHERE (rowid % n) = 0 ~~~