Hi Consider a self join to start with. regards, Martin
On 22/06/2018 18:49, Doherty, Adam wrote:
Hi all:
I'm trying to figure how to calculate the time delta between two events. My events have a timestamp, event source, event type, and an event state and event id.
So an event looks like - event_date_time event_source event_type event_state event_id 2018-06-22 09:05:07.000000 MODULE123 TYPEABC ACK 24567890 2018-06-22 11:32:14.000000 MODULE123 TYPEABC UNACK 24812266
This makes up a unique "event", start to finish. However I have hundreds or thousands of entries between and I want be able to group them together in their unique pairings as above.
I'm not sure how to wrap my head around this one.
Adam Doherty _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list