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 are types of joins?

945

What are system versioned tables?

1008

Mention what is the function that is used to transfer a pl/sql table log to a database table?

967

What will you get by the cursor attribute sql%found?

945

How does postgresql compare to oracle/db2/ms sql server/informix?

1015

How can I speed up sql query?

934

How to use distinct and count in sql query? Explain

998

What does pragma mean?

1025

How do you rank data in sql?

981

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

1010

what is a primary key? : Sql dba

1023

what is bdb (berkeleydb)? : Sql dba

1007

Does sql*plus also have a pl/sql engine?

1065

What is a string data type in sql?

1020

what are ddl statements in mysql? : Sql dba

1171