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

how to include character strings in sql statements? : Sql dba

1072

What is Collation Sensitivity ? What are the various type ?

952

What are the ways on commenting in a pl/sql code?

1135

What problem one might face while writing log information to a data-base table in pl/sql?

1166

What is vector point function?

1054

What is form and report?

990

What is Histogram?

1559

How do you write a subquery?

1029

Is a table valued function object?

1023

What program will open a mdb file?

964

What is on delete set null?

1090

What is the difference between pl and sql?

1093

What are pl sql data types?

1013

What is a design view?

924

What are sql built in functions?

937