Struggling through these has made it clear to me how outdated my SQL knowledge is. Can anyone recommend a favorite guide to all the neat stuff in SQL:2003 for a postgresql/mariadb user?
I don’t know of any guides, but I found the Postgresql docs to be good enough: Window function list and window function usage syntax.
Postgres-centric presentations. Not specifically about SQL:2003. I admit I haven’t seen them all, but I attented one of the “Window Magic” presentations and it was very good. Which is not surprising given the author, Bruce Momjian :)
Cool quiz! I haven’t used window functions very often, but I breezed through most of them once I looked up the syntax to refresh myself.