Question : (edited – I oversimplified the original problem) I’m trying to figure out a MySQL query that will collapse […]
Tag: gaps-and-islands
Merge Only Events that Start immediately after the Previous Event without any Gap
Question : How can i merge only the dates occur subsequently.? (i.e, The Next Event begins immediately after the previous […]
Measure time duration between events, partitioned by hours
Question : I have the following table in PostgreSQL 9.4, which persists users log on/off events (log on is event_type […]
How to select blocks with sequential data and aggregate the ids
Question : I have the following table: id(int) startDate(timestamp) endDate(timestamp) plan_id(int) planned(bool) machine(int) ————————————————————————————————————– 2005 ‘2019-01-16 08:29:24.872736’ ‘2019-01-16 08:30:23.529706’ 34 […]
Query to find if there are more than X occurences within any period of given length minutes
Question : I have spent many hours thinking about a solution for my problem but I give up. Let’s imagine […]
Solving “Gaps and Islands” with row_number() and dense_rank()?
Question : How does one solve the islands part of gaps-and-islands with dense_rank() and row_number(). I’ve seen this now a […]
return continuous set of IDs based on two other columns
Question : Given a table such as the one below, how can I ask PostgreSQL to return the first set […]
Stored procedure to check for missing fields in a table
Question : I have a stored procedure that accepts a string parameter, a comma separated list of required column names […]
Is WITH RECURSIVE the right tool for my task?
Question : Table setup: create table users(id bigserial, group_id bigint); insert into users(group_id) values (1), (1), (2), (1), (3), (3); […]
Help with query
Question : I have following data. I am trying to get the number of days the project stayed in a […]