#window-functions

SQL Window Functions, Explained Simply

Window functions in SQL without the headache: OVER, PARTITION BY, ROW_NUMBER, RANK, and running totals. Keep every row while you rank and total, live.