Tags / window-functions
Understanding the Limitations of ROW_NUMBER() and Finding Alternative Solutions for Partitioned Data
Understanding the Limitations of Min(date) in SQL Case Statements: Workarounds without Window Functions
Solving Duplicates in Time Periods from Repeated Groups Using SQL Analytics