Using Window Functions to Set Values: A Postgres Approach.

Selecting Records Where Only One Parameter Changes Using SQL and LINQ: A Deep Dive

Using ROW_NUMBER(), PARTITION_BY, and TOP/MAX to Get Maximum Values at Specific Positions in SQL