SQL SERVER: ROW_NUMBER () vs. DENSE_RANK ()

added by lionofdezert
1/10/2011 5:55:37 AM

1 Kicks, 106 Views

ROW_NUMBER() is well known to return sequential number of rows with in a partition of a result set. DENSE_RANK()provide you facility to get distinct rank number for partition in a result set. When we need it and how to use it.


0 comments