Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL query
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01666437
Message ID:
01666454
Vues:
50
>Muito obrigado, Antonio!
>I confess that I gave a sloppy description of the problem.
>Please ignore the second column (Bore).
>I am looking for the largest difference of depth in two consecutive records. I recieve these data from a measuring device potentially in more than one csv files which I append into that table. Primarily the raw data are not even sorted by depth, so first of all I may have to "translate" these data into an ordered table with an additive column "Position" and then perform your suggestion with the modification of joining the table against itself on D1.position = D2.position +1. (see new attachment)
>Would you agree with that?
>
>Best regards

Sounds about right as long as there are no gaps in Position column values
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform