Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
what is the difference between rank and dense rank?
September 13, 2010
please give me exact difference of the above?
Syed Shakeer Hussain
Posted Date: September 14, 2010 Points: 5
Rank() doesnot assign Uniwue Numbers.
DenseRank() like Rank() doesnot assign Unique Number,but it does assign contiguous numbers
check this link for more information with good Example
Posted Date: September 18, 2010 Points: 5
The RANK()function in SQL Server returns the position of a value within the partition of a result set, with gaps in the ranking where there are ties.
The DENSE_RANK() function in SQL Server returns the position of a value within the partition of a result set, leaving no gaps in the ranking where there are ties.
To post reply
Related Questions Related Questions
rank calculation for marksheet
how to do rank calculation
difference between an EXE and a DLL
Difference Between console application and windows application?
Difference between Web Garden and Web Farm
Difference Between Response.Write and Response.Output.Write?
Difference between Language and package
Difference between JDK and SDK
Difference Between SDK and IDE
What is the difference between Get and Post method?
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend