Tags / gaps-and-islands
SQL Running Total with Cumulative Flag Calculation Using Common Table Expression
Creating Date Ranges from Day-Based Data Using Oracle SQL
Selecting Records Where Only One Parameter Changes Using SQL and LINQ: A Deep Dive
Solving Duplicates in Time Periods from Repeated Groups Using SQL Analytics