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

Getting Top Records per Category: Using Window Functions to Achieve Complex Queries.