Using Window Functions to Identify Long Chains of Repeating Values in Binary Data

Selecting Sportsmen in Oracle SQL: Approaches and Limitations for Consecutive Competitions