Understanding ROW_NUMBER() Window Functions

Window functions calculate metrics across rows linked to the current record. ROW_NUMBER() sequentially indexes partition rows. Try it to rank employee salaries within each department!