Click here to Skip to main content
15,847,427 members
Articles / Programming Languages / SQL

What is the Difference between ROW_NUMBER(), RANK() and DENSE_RANK()?

Rate me:
Please Sign up or sign in to vote.
4.97/5 (15 votes)
26 Sep 2014CPOL2 min read 193.5K   21  
This tip will explain the difference between these three functions.


Daily Counts


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Software Developer (Senior) Mindfire Solutions
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions