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






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

Post New Answer




More SQL PLSQL Interview Questions

What is the difference between sql/pl-sql/embeded sql?

3 Answers  


What is a 'instead of trigger'?

3 Answers   TCS, Eenadu,


in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  


A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,


I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  






what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,


How will you make performance better for application including front end and back

2 Answers   Metric Stream,


What is the Subquery?

4 Answers  


What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   TCS, Cap Gemini, Infosys,


If we update a complex view, is base table will get update ?

2 Answers   HCL, Ardee Technologies,


if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,


if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  






Categories