I found this nice post from Laurent Schneider the other day and wanted to comment, but my comments were a bit more of a digression and discussion, so I’ve blogged it and put a link on the comments of the post by Laurent. I’d always used the ROW_NUMBER method myself until I read this and [...]
Archive of posts tagged analytics
RANK v DENSE_RANK v ROW_NUMBER
I was asked a question by one of my users about the difference between the RANK and ROW_NUMBER analytics yesterday, so here is a post on it… RANK, ROW_NUMBER and also DENSE_RANK are very useful for taking a set of rows and ordering them in a defined manner, whilst giving each row a “position value”. [...]