This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » sql language to remove repeat data within specific timeline
Reply

sql language to remove repeat data within specific timeline

Glen Hynes
Member



Since: 14 May 2009
Posts: 1
Posted 14 May 2009 13:14:20

hey all..

im new enough with sql language and need help with a query that i am trying to show..

i pull alarm data from a database and it gives me all the alarms that occur with the following columns..

Tool time_occured alarmtext


When I run the query say it gives me 5 alarms….


Tool time_occured alarmtext

#1 12:20 DOOR OPEN

#1 12:21 DOOR OPEN

#1 12:30 DOOR OPEN

#2 12:20 DOOR OPEN

#2 12:24 DOOR OPEN



What I need is the table to show the following…


Tool time_occured alarmtext

#1 12:20 DOOR OPEN

#1 12:30 DOOR OPEN

#2 12:20 DOOR OPEN



I want to show alarms for tools… but not show an alarm if the same alarm occurs within 5 minutes of the first alarm of that type on the unique tool…

Is this doable??



hey all..

im new enough with sql language and need help with a query that i am trying to show..

i pull alarm data from a database and it gives me all the alarms that occur with the following columns..

Tool time_occured alarmtext


When I run the query say it gives me 5 alarms….


Tool time_occured alarmtext

#1 12:20 DOOR OPEN

#1 12:21 DOOR OPEN

#1 12:30 DOOR OPEN

#2 12:20 DOOR OPEN

#2 12:24 DOOR OPEN



What I need is the table to show the following…


Tool time_occured alarmtext

#1 12:20 DOOR OPEN

#1 12:30 DOOR OPEN

#2 12:20 DOOR OPEN



I want to show alarms for tools… but not show an alarm if the same alarm occurs within 5 minutes of the first alarm of that type on the unique tool…

Is this doable??



Reply to this topic

Message
Reply
Follow us on Facebook Follow us on twitter Subscribe to the RSS feed
Activate your free membership today | Login | Currency