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 are the limitations of identity column? : Transact sql

can sql servers linked to other servers like oracle? : Sql dba

write an sql query to find names of employee start with 'a'? : Sql dba

Can you have more than one key in a database?

how to enter numeric values as hex numbers? : Sql dba

What does where 1 1 mean in sql?

What are the differences between Database Trigger and Integrity constraints ?

what is a constraint? Tell me about its various levels. : Sql dba

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

if a table is getting updated what happens if a function is called from sql query?

Is progress software supports to ( pl/sql )?

what is schema? : Sql dba

For more SQL PLSQL Interview Questions Click Here