Troublesome Query

Martin Kersten martin.kersten at cwi.nl
Sat Jun 23 14:24:01 CEST 2018


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 at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
> 


More information about the users-list mailing list