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

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

Question Posted / shipra gupta

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

More SQL PLSQL Interview Questions

What is the difference between SQL table and the PLSQL table?

How to find the count of letter "L" in HELLO

how to retrieve the top 3 salaries of the table using rownum

What are sql injection vulnerabilities?

What are the different schemas objects that can be created using pl/sql?

How many columns should be in an index?

Does truncate release storage space?

what is the difference between undefined value and null value? : Sql dba

What is different between union and minus?

What is rownum in sql?

How to create an array in pl/sql?

What is microsoft t sql?

For more SQL PLSQL Interview Questions Click Here