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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is dbms? : Sql dba

530


How would you reference column values before and after you have inserted and deleted triggers?

614


Is it possible to include an insert statement on the same table to which the trigger is assigned?

549


What are the types of subqueries?

560


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

582






Can we call dml statement in function?

531


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

586


Which version of sql do I have?

549


What does truncate mean in sql?

526


How to raise user-defined exception with custom sqlerrm ?

669


what is auto increment? : Sql dba

563


What is prepared statement in sql?

533


What does the file extension accdb stand for?

538


What are character functions?

619


what are wild cards used in database for pattern matching ? : Sql dba

534