salary R DR 800 1 1 800 1 1 200 3 2

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

Question Posted / shipra gupta

Answer Posted / shipra gupta

salary R DR
800 1 1
800 1 1
200 3 2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is bulk compiling in pl/sql.?

1189

Why join is faster than subquery?

1159

Can we create table in function?

1017

Explain character-manipulation functions?

1174

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1065

What is the difference between the conventional and direct path loader? : aql loader

1193

What are the parts of a sql statement?

1143

Are views faster than queries?

1038

What is the difference between local and global temporary table?

1088

What is the purpose of design view?

1073

Why is %isopen always false for an implicit cursor?

1151

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

1082

How are functions and procedures called in PL/SQL?

1307

Is it possible to sort a column using a column alias?

1097

What are variables in pl sql?

1230