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 do I find duplicates in two columns?

1162

Why we use stored procedure instead of query?

997

What is a sql statement?

951

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1436

What is cost in sql execution plan?

977

Is ms sql traffic encrypted?

920

What is a memo field?

967

What is ttitle and btitle?

1061

What is the difference between jpql and sql?

1091

What is pl sql script?

1026

How would you pass hints to the sql processor?

980

List the various privileges that a user can grant to another user?

1038

What is composite primary key in sql?

996

What is difference between table and view?

1048

How do sql databases work?

990