General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I have a range of some id numbers from 100001 to 200000 and I want to select from mutable more the 1000 records in row that meet a certain condition
Hi Bill,
I'm a little unclear but it sounds like you want to find a record that meets your condition and copy either the next 1000 sequential records or the next 1000 sequential records that meet your condition. If you set an order in your table and set a filter that meets your condition you can use COPY TO... NEXT 1000. You can't use COPY TO ... NEXT 1000 FOR ... because the FOR clause is evaluated against the next 1000 records and you'll get whatever meets your FOR condition in the next 1000 records, not the next 1000 that meet the condition.
If this isn't what you want, post some sample data and describe the results you want.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only