gaps-and-islands

116 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How to find two consecutive rows sorted by date, containing a specific value?
user_17326600
•
2
2
587
gaps-and-islands window-functions date sql-server sql
Capturing consecutive year ranges with break in hive
user_136446850
•
2
2
162
hiveql gaps-and-islands hive window-functions sql
How to count how many consecutive days a user is tagged as orange in MYSQL?
user_65370670
•
2
2
50
gaps-and-islands window-functions group-by mysql sql
SQL query to find correct pairs of engine running
user_58100080
•
2
1
55
gaps-and-islands group-by date mysql sql
Subtract previous row to calculate column value in MS SQL
user_16953420
•
4
2
936
gaps-and-islands window-functions date sql-server sql
Minimum and maximum dates within continuous date range grouped by name
user_67999030
•
2
3
407
gaps-and-islands sql-server sql
How to sum the values of a column for several rows?
user_37719690
•
4
5
1732
clickhouse gaps-and-islands group-by date sql
Need Help for SQL MIN MAX Group By and AGGREGATE
user_76156090
•
2
1
68
gaps-and-islands window-functions tsql sql-server sql
How to get select rows that have first occurrences before column value changes in MYSQL8
user_19492570
•
3
4
62
mysql-8.0 gaps-and-islands window-functions mysql sql
SQL How to retrieve first row when value changed?
user_114446610
•
3
2
622
gaps-and-islands mysql sql
Hot Questions