hi...I've tried to think about this for 2 days but I can't really find the solution. Hope anyone can help. What statement should I write for this:There is a table of Parcel. In the table there are ParcellId and the timestamp. I have to select parcels that have the time between two parcells is only less than 3 seconds. Others less than 3 sec should be ignored.
carsein
0
Newbie Poster
Recommended Answers
Jump to PostAre talking about a form of soft realtime? Please try to explain why is 3s limit so important for you, maybe it would be much easier to help you.
Jump to PostSo you have many records and you want to see only pairs of rows created in less than 3 sec time window, right?
All 5 Replies
VIeditorlover
0
Junior Poster
carsein
0
Newbie Poster
VIeditorlover
0
Junior Poster
carsein
0
Newbie Poster
sknake
1,622
Senior Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.