1. 7
  1.  

  2. 1

    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?

    1. 2

      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.

      1. 2

        https://momjian.us/main/presentations/sql.html 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 :)

      2. 1

        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.