Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement