Tags / window-functions
Understanding SQL's Dense_Rank and Group By: A Deep Dive - How to Use DENSE_RANK() with GROUP BY for Powerful Data Insights
Solving Duplicates in Time Periods from Repeated Groups Using SQL Analytics
Replacing Null Values with a Default Value using Window Functions in SQL
Understanding the Limitations of Min(date) in SQL Case Statements: Workarounds without Window Functions