Answer Posted / soujanya
RANK calculates the rank of a value in a group of values.
Rows with equal values for the ranking criteria receive the
same rank. Oracle then adds the number of tied rows to the
tied rank to calculate the next rank. Therefore, the ranks
may not be consecutive numbers.
eg: SELECT RANK(15500, .05) WITHIN GROUP
(ORDER BY salary, commission_pct) "Rank"
FROM employees;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to write date and time literals in oracle?
What is logical backup in oracle?
What is a procedure in oracle?
What is data type in oracle?
How are extents allocated to a segment?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Query to retrieve record for a many to many relationship ?
How to filter out duplications in the returning rows using oracle?
How to display employee records who gets more salary than the average salary in the department?
How to use null as conditions in oracle?
What is oracle data type?
does the query needs a hint to access a materialized view?
what is insert all statement in sql
How to test null values?
