3 ms·
It's surprising to me that someone can run into window functions earlier than subqueries. I guess my background with MySQL which only recently supported window
by Macha 7y ago
It's surprising to me that someone can run into window functions earlier than subqueries. I guess my background with MySQL which only recently supported window functions affected my perspective there.
- firasd 7y agoHer question that starts the post is about doing it in a single query (no subqueries.) I kinda had this misunderstanding on Twitter too when responding to an earlier diagram of hers https://twitter.com/firasd/status/1172874054002307073 https://twitter.com/firasd/status/1172874054002307073
- pvorb 7y agoI've had use cases for subqueries long before I knew about window functions. This was just the example from the article where subqueries provide a solution.