3 ms·

Not to tack on too much hyperbole but window functions are amazing and can save you from doing a lot of self joins.

• masklinn 7y ago
  I don't know that that's hyperbole. Many folks do feel that window functions were no less than a revolution.
• pixelbath 7y ago
  Same with CTEs. In the last year I've worked with both and they really change the game for nontrivial queries.