gaps-and-islands

116 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Fill in gaps in year sequence in SQL Server
user_19003470
•
5
8
784
gaps-and-islands window-functions datetime sql-server sql
SQL - How to select x number of rows prior to a specific row
user_73734400
•
2
2
140
amazon-redshift gaps-and-islands window-functions datetime sql
Calculate time correctly between 2 date range
user_62601570
•
2
1
72
gaps-and-islands datetime sql-server-2008 sql-server sql
Group islands of contiguous dates, including missing weekends
user_136724340
•
2
1
115
gaps-and-islands window-functions count sql-server sql
Get start of a time period from repeated groups
user_128420040
•
2
3
78
gaps-and-islands window-functions postgresql sql
SQL Conditional Look Ahead
user_136052140
•
3
3
381
gaps-and-islands window-functions select oracle sql
Optimizing group by query with union
user_43824330
•
2
4
301
gaps-and-islands select group-by mysql sql
Calculating users' "busy duration" taking into account overlapping activities
user_140968440
•
2
4
94
gaps-and-islands window-functions datetime oracle sql
How to merge consecutive rows of date and time using MySQL
user_32973610
•
3
3
669
gaps-and-islands window-functions datetime mysql sql
Find previous number in column that is not missing from a sequence
user_11840030
•
2
1
41
gaps-and-islands window-functions datetime oracle sql
Hot Questions