gaps-and-islands

116 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Merge lines over timespan in SCD2 table
user_148589730
•
2
4
124
scd2 gaps-and-islands tsql sql-server sql
Selecting count of consecutives dates before and after a specified date based on start/end
user_37764300
•
2
2
70
gaps-and-islands sql-server-2012 datetime sql-server sql
Finding multiple consecutive dates (datetime) in Ruby on Rails / Postgresql
user_19327230
•
2
2
250
gaps-and-islands datetime postgresql ruby-on-rails sql
Retrieve rows from sql table based on specific value
user_147947800
•
2
1
78
gaps-and-islands where-clause sql-server sql
Using SQL to group consecutive items that share a common status (dummy data included)
user_10610660
•
2
1
126
gaps-and-islands recursive-query datetime sql-server sql
Numbering rows based on multiple fields changes (incluging an "invisible" one) in PostgreSQL
user_110744160
•
2
2
32
dense-rank gaps-and-islands postgresql sql
How do I make my CTE search through my data again in T-SQL/MSSQL?
user_49417910
•
4
1
51
gaps-and-islands recursive-query common-table-expression tsql sql-server
How would I extract only the latest week from a select over statement in Hiveql?
user_139645630
•
3
1
31
hiveql gaps-and-islands greatest-n-per-group sql
How to identify rows per group before a certain value gap?
user_126371800
•
2
3
144
gaps-and-islands window-functions sql-update postgresql sql
SQL -- How do I write a select statement that finds customers who placed orders on 5 consecutive days
user_57864780
•
2
3
509
gaps-and-islands count datetime sql-server sql
Hot Questions