how are rank and dense rank being alloted for column with same values over a particular column



how are rank and dense rank being alloted for column with same values over a particular column..

Answer / shipra gupta

salary R DR
800 1 1
800 1 1
200 3 2

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  


How many row comparison operators are used while working with a subquery?

0 Answers  


What is thread join () in threading?

0 Answers  


What is server name sql?

0 Answers  


How to read xml file in oracle pl sql?

0 Answers  






Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  


What is union, minus and interact commands?

0 Answers  


What is an example of translating a date into julian format?

0 Answers  


What is window clause?

1 Answers   TCS,


what are the methods using performance tunning in sql and pl/sql

2 Answers  


What is cursor and why it is required?

0 Answers  


how to calculate the difference between two dates? : Sql dba

0 Answers  


Categories