Tags / gaps-and-islands
Grouping Consecutive Rows Based on One Column Using SQL Row Number Functions
Detecting Changes in Columns Using Redshift Window Functions for Data Analysis
Removing Consecutive Duplicates in Oracle SQL Using LAG() with a Condition
Fixing Discontinuous Date Ranges with Oracle SQL: A Step-by-Step Guide