Tags / gaps-and-islands
Solving Duplicates in Time Periods from Repeated Groups Using SQL Analytics
Selecting Sportsmen in Oracle SQL: Approaches and Limitations for Consecutive Competitions
Optimizing MySQL Update Queries for Consecutive Rows
Splitting a Column Value into Two Separate Columns in MySQL Using Window Functions