select every nth record

[kimdd]

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.

 

[Lynn Trapp]

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;