SQL Is Surviving, Franklin: Now Rows Are Competing

If you have survived SELECT, WHERE, JOIN, GROUP BY, subqueries, and CTEs, congratulations. Franklin has now discovered window functions. And window functions are where SQL starts doing something that feels a little suspicious. They can look at other rows without collapsing the rows you already have. You can have: An employee's salary and their...