select every nth record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to select every nth record in a query? For instance, say I am
trying to pull every 5th record of a table.
 
That depends on how your database is designed. Typically there is no such
thing as a "first," "second," or "third," etc. record. However, if you
have some unbroken sequential number field you could do something like this:

Select YourIdField, SomeOtherField, AnotherField
From YourTable
Where YourIDField MOD 5 = 0;
 
Back
Top