Various Meanings of SQL’s PARTITION BY Syntax – Java, SQL and jOOQ.

For SQL beginners, there’s a bit of an esoteric syntax named PARTITION BY, which appears all over the place in SQL. It always has a similar meaning, though in quite different contexts. The ...