I found out that a lot of devs found row_number() when they were looking for way to do pagination, but never come across rank and dense_rank functions. Nice art

I found out that a lot of devs found row_number() when they were looking for way to do pagination, but never come across rank and dense_rank functions. Nice article, it explain difference between these three functions in a much simplier way msdn and technet does.