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

Does a primary key have to be a number?

what command is used to create a table by copying the structure of another table including constraints ?

what is difference between pass by value and eference by value in oracle plsql

What sql does db2 use?

What is cursor status?

what is not null constraint? : Sql dba

what is the difference between union and union all

What does the argument [or replace] do?

how to use myisamchk to check or repair myisam tables? : Sql dba

How to use sql statements in pl/sql?

is mysql query is case sensitive? : Sql dba

Can we call a function containing dml statements in a select query?

For more SQL PLSQL Interview Questions Click Here