Doug Kline compares three window functions: RANK, DENSE_RANK, and ROW_NUMBER:
— so let’s say that we’ve created a contest
— places in the contest (top place, 2nd place, etc.)
— will be determined by the test score— in other words, we’re not so concerned with the raw score
— but rather, we’re interested in the *relative* score
— and the order in which people appear, based on their score— we can use the ROW_NUMBER() function to give a
— ‘ranking’ to each record, based on Score
Doug’s post is a video and an extended script so you can follow along.