Code Snippet

Just another Code Snippet site

The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()

One of the best features in SQL are window functions. Dimitri Fontaine put it bluntly: There was SQL before window functions and SQL after window functions If you’re lucky enough to be using …

Source: The Difference Between ROW_NUMBER(), RANK(), and DENSE_RANK()


Leave a Reply

Your email address will not be published. Required fields are marked *