What is the difference between rank and dense_rank?
- 1 Answers
- 1225 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
List the ways in which dynamic sql can be executed?
Why use identity in sql server?
do you know how to configure db2 side of the application? : Sql server database administration
Can you index views?
List out the different types of locks available in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How raid can influence database performance?
Why and when do stored procedure recompile?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is self contained sub query?
What is a coalesce function?
Disadvantages of the indexes?
Can one drop a column from a table?
Equi join and non equi join is possible with sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
