3 ms·
SQL Trick: row_number() is to SELECT what dense_rank() is to SELECT DISTINCT
- vittore 13y agoI 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.