Posted by Ellen K on 10/01/98 11:39

If your table has a numeric identifier, use the modulus (%) operator.

Using your example of 500,000 rows divided by 20,000 samples = 25, use
WHERE Identifier % 25 = 0
..

HTH. :)

• Next in forum: Re: How do I NTH Select in SQL????
• Prev in forum: Re: Help with tricky T-SQL
• Thread view: Re: How do I NTH Select in SQL????

[Reply to this message]