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

Can a foreign key be a duplicate?

Does asenumerable execute the query?

Types of locks in database ?

Should I use mbr or gpt?

What are some predefined exceptions in pl/sql?

How do you delete duplicates in sql query using rowid?

How many columns should be in an index?

Is it possible to create the following trigger: before or after update trigger for each row?

What is a sql driver?

What is a column in a table?

What is mutating table error?

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

For more SQL PLSQL Interview Questions Click Here