what is the use of rank function?
- 1 Answers
- 5230 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the difference between formal parameters and actual parameters?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
how the indexes are stored in the Oracle Database?
What is Row Chaining ?
What is Water Mark in Oracle?
Can the default values be assigned to actual parameters?
What are the differences between primary key and unique key?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to use "startup" command to start default instance?
interview questions with answer for cts
How to use select statement to count the number of rows in oracle?
Why does oracle 9i treat an empty string as null?
Oracle General 
