SQL Window Functions

OVER and PARTITION BY, ranking, LAG/LEAD and frame clauses — per-row analytics that keep every row instead of collapsing groups.