Slower than aneeshattinga!...and slightly different but essentially the same
Main Topics
Browse All TopicsI have attached the data from my datatable with the sample data for OCtober.
You can see that the Data column is increasing in value every 15min. This is the correct operation of the system. A new value is added to the Data column every 15min, and the timestamp logged.
You will notice that I've highlighted some of the rows in yellow. These rows have Mistakenly been modified by myself by using a duff query. You will also notice that the highlighted rows have a larger increase, and the value is higher than the next record, which is my problem.
I need a query to scan through all of the records and return the Data, recordnumber and timestamp where the problem rows exist. i.e. have a greater 'Data' value than the next row (e.g. row 5 has a larger value than row 6)
Hope this is enough detail.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: aneeshattingalPosted on 2009-10-27 at 13:26:58ID: 25677048
select *
from Tbal a
where exists (select 1 from tbal b where a.recordnumber+1 = b.recordnumber and a.TLInstance
= b.TLInstance
and a.data > b.data )