gaps-and-islands

116 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
SQL - Convert Time Series Events into On/Off Pairs (handling potential missing On's or Off's)
user_52333160
•
4
2
253
gaps-and-islands datetime tsql sql-server sql
PostgreSQL select rows having same column values
user_133196350
•
2
4
1194
gaps-and-islands window-functions postgresql sql
SQL Counting Consecutive Days in Date Ranges
user_15004830
•
2
2
484
gaps-and-islands count datetime sql-server sql
How to aggregate data with slowly changing dimension
user_138420100
•
2
2
369
gaps-and-islands window-functions teradata datetime sql
SQL - Time difference within same column
user_143168190
•
2
1
243
gaps-and-islands window-functions datetime sql-server sql
Pivot with row_number() in PostgreSQL
user_37070190
•
2
1
45
gaps-and-islands pivot window-functions postgresql sql
Calculate/Derive first Start Date in continuous date spans
user_94299340
•
2
2
64
gaps-and-islands window-functions datetime postgresql sql
Rank based on cumulative value
user_42272870
•
5
2
111
rank gaps-and-islands window-functions sql-server sql
Using RANK() in SQL as ID Number for Groups of Records
user_45736360
•
2
3
48
gaps-and-islands window-functions datetime sql
SQL lead function SQL Netezza
user_57380920
•
2
2
301
netezza gaps-and-islands window-functions datetime sql
Hot Questions