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
what is dbms? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What are the types of subqueries?
What will you get by the cursor attribute sql%notfound?
Can we call dml statement in function?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Which version of sql do I have?
What does truncate mean in sql?
How to raise user-defined exception with custom sqlerrm ?
what is auto increment? : Sql dba
What is prepared statement in sql?
What does the file extension accdb stand for?
What are character functions?
what are wild cards used in database for pattern matching ? : Sql dba