1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between rank and dense_rank?

Question Posted / abhishek mishra


What is the difference between rank and dense_rank?..

Answer / Sukveer Singh Aswal

Rank assigns a unique number to each row in a result set based on a specified ordering, with gaps allowed if there are ties. Dense_rank assigns a unique number without any gaps when there are ties.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Get Current System Date Time

2 Answers  

Why Master database is required?

1 Answers   Abacus,

What is 3nf normalization?

1 Answers  

Explain sql server service broker?

1 Answers  

what is the maximum size of sql row in mssql?

1 Answers  

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1 Answers  

where can you add custom error messages to sql server? : Sql server administration

1 Answers  

How do I view a procedure in sql server?

1 Answers  

How do I determine how many instances of sql server are installed on a computer?

1 Answers  

What is stretch database in sql server?

1 Answers  

what is Covering Index ?

3 Answers   Thomson Reuters,

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

For more SQL Server Interview Questions Click Here
Categories