I have a large table of x,y,z coordinate values. The table contains over a million records.
Is there a convenient way to select and retain only a certain, lesser number of records using a query?
I'd like to select, say, every fourth record and retain that record, and discard the others, creating a new table in the process. In general, I'd like to be able specify the frequency of the records retained (say every tenth, instead of every fourth record). Do I need to write code to allow this generalization, or can I control the record-retention frequency in a query?
Thanks for your feedback.
Tim Barbour
timbar@att.net
Is there a convenient way to select and retain only a certain, lesser number of records using a query?
I'd like to select, say, every fourth record and retain that record, and discard the others, creating a new table in the process. In general, I'd like to be able specify the frequency of the records retained (say every tenth, instead of every fourth record). Do I need to write code to allow this generalization, or can I control the record-retention frequency in a query?
Thanks for your feedback.
Tim Barbour
timbar@att.net