Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL query
Message
From
15/02/2019 13:00:54
 
 
To
15/02/2019 10:49:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01666437
Message ID:
01666453
Views:
57
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
Eugen
New Year's pledge: Last year I learned so much from my errors that I decided to make some more.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform