Rails Active Record find every 10th record

Question

I'm looking for a way to find every 10th record in my 'Lang' database starting with the first record. Something like this:

@words = Lang.find(records with ids of 1,11,21,31,41...)

possible duplicate of [How do you select every n-th row from mysql](http://stackoverflow.com/questions/858746/how-do-you-select-every-n-th-row-from-mysql) — jvnill, Jun 05 '15 at 01:25
@jvnill That question helps but its not active record its just mysql but thanks it was a good starting point for me — MZaragoza, Jun 05 '15 at 01:50

MZaragoza · Accepted Answer · 2015-06-05T02:42:26.260

1

you can do something like this

total = Lang.count
ids = (1..total).step(10)
Lang.where(id: ids.to_a)

After thinking about this. I think if you are looking for a sample the best thing to do is

Lang.all.shuffle.first(30) # this returns 30 random rows from the langs table

I try to do it as clean as I could

I hope that this helps

edited Jun 05 '15 at 02:42

answered Jun 05 '15 at 01:47

MZaragoza

how about a deleted record in that sequence ? – Nithin Jun 05 '15 at 02:02
1

So lets say that row 11 is deleted then you want 13 or 21? – MZaragoza Jun 05 '15 at 02:15
are you looking for just a random sample of records? – MZaragoza Jun 05 '15 at 02:16
Lang.all.shuffle.first(10) # I think that this would work for what you are looking on doing – MZaragoza Jun 05 '15 at 02:17
if my sequence has deleted record in between which may be 11, 12, i'll need 1,13, so on, it's just an example. deleted ids cannot be expected, the result should be dynamic. – Nithin Jun 05 '15 at 02:23
Quit adding stupid contingencies in the comments, and ask a new question if you have one... – Brad Werth Jun 05 '15 at 02:33

1 Answers1