A cross-platform—Microsoft SQL Server, Oracle Database, and MySQL—perspective on SQL’s windowing functions and analytical OVER() clause and some of their more advanced capabilities or lack thereof. The journey to this presentation started last year at the Columbus PASS SQL Saturday. During my research, Jeremiah Peschka (blog | twitter), who coincidentally was a member of Columbus [...]