gaps-and-islands

116 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Find records where length of consecutive values is less than threshold
user_98485490
•
2
3
152
gaps-and-islands window-functions group-by postgresql sql
SQL query to group by chronological series
user_88339050
•
3
1
191
gaps-and-islands aggregate-functions window-functions sql database
Row lumping, cycle dates
user_88752560
•
2
3
50
gaps-and-islands cycle date oracle sql
Find common date range from a set of overlapping date ranges
user_68524510
•
3
2
538
gaps-and-islands overlap sql-server sql
Longest Consecutive Days Count for BigQuery
user_27614250
•
5
2
1416
google-bigquery gaps-and-islands mysql
T-SQL Identifying gaps in broken sequence of dates
user_20324140
•
3
3
438
gaps-and-islands sequence tsql sql-server
Select min start and max end for consecutive periods in SQL Server 2012+
user_17068890
•
4
2
811
gaps-and-islands partitioning sql-server
Group contiguous rows in PostgreSQL
user_106205140
•
4
1
550
gaps-and-islands group-by postgresql sql
Group rows by an incrementing column in PostgreSQL
user_106205140
•
2
1
99
gaps-and-islands postgresql sql
PostgreSQL array_agg but with stop condition
user_51635320
•
2
2
271
array-agg gaps-and-islands select postgresql sql
Hot Questions