gaps-and-islands

116 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to form groups of consecutive dates allowing for a given maximum gap?
user_40168620
•
6
4
247
gaps-and-islands window-functions postgresql sql
How to get the biggest value in any consecutive range
user_140638810
•
2
2
74
dense-rank gaps-and-islands recursive-query window-functions mysql
How to group data based on continuous date range?
user_67329060
•
2
1
206
gaps-and-islands sql-server sql
Combine periods by user
user_188528720
•
1
2
72
gaps-and-islands datetime sql-server sql
SQL Cursor to join periods of dates into single row
user_101914930
•
2
2
78
gaps-and-islands tsql sql-server sql
Detect flickering in list of durations values
user_151860
•
3
2
110
gaps-and-islands c#
How to check if a group has three consecutive values in a column?
user_71195010
•
2
4
123
gaps-and-islands window-functions mysql sql
Oracle SQL - How to return common date periods and "divide" when there are gaps between periods
user_136347530
•
1
2
82
gaps-and-islands oracle sql
T-SQL - Aggregate (MIN/MAX date) considering chronological sequence - SQL Server 2012
user_180281500
•
2
1
91
gaps-and-islands sql-server-2012 tsql sql-server sql
A more complex Island & Gaps problem in SQL
user_179484170
•
2
2
201
gaps-and-islands oracle sql
Hot Questions