Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Help with query to DBF table!
Hello,
We get a dbf table with field page_number. Field page_number should have continuing values like: 1,2,3,..., 100. However, constantly we get the dbf table with missing values. For example in this list: 1,2,3,6,7,8,9,10. It's missing number 4 and 5.
Is there any SQL query that we can run to know which values are missing in the DBF, knowing first value and last value of the DBF?
I'm trying to make one, but I'm stuck with that.
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- Participating Experts
- 3
- Solution Grade
- A
Posted on 2009-10-15 at 16:16:51ID: 26270624
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.