Willem Booysen
Accountant at whbooysen@gmail.com
Accountant turned Accidental DBA. Financial Manager and Accounting Partner during the day and SQL scripter during the night.
Upcoming presentations
No upcoming presentations...
Past presentations
Window Functions
Window Functions are easy...ish once you understand the syntax and how one needs to approach your data.
Window Functions appear to be generally underutilised in the real world. Compared to CTE's and basic Select queries, one seldom sees Window Functions in SQL blogs, stackoverflow pages, forums, etc. (unless the article is dedicated to Window Functions). My opinion is that this is due to the syntax and different way of thinking about Window Functions compared to normal SQL syntax and use. Thi...
