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

How do I run pl sql in sql developer?

0 Answers  


What is sql*loader and what is it used for? : aql loader

0 Answers  


----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,


how are mysql timestamps seen to a user? : Sql dba

0 Answers  


List out the acid properties and explain?

0 Answers  






Types of optimization?

6 Answers   Microsoft,


What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,


what is foreign key? : Sql dba

0 Answers  


What programs use sql?

0 Answers  


Why do we need unique key in a table?

0 Answers  


How is indexing done in search engines?

0 Answers  


How insert into statements in sql?

0 Answers  


Categories