Interested to Buy Any Domain ? << Click Here >> for more details...
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 Truncate Table in Oracle
What is the difference between translate and replace in oracle?
What is null value in oracle?
How to drop an existing table in oracle?
What would you do with an in-doubt distributed transaction?
How to start a specific oracle instance?
what are archived logs?
How to create tables for odbc connection testing?
How to rename an existing table?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
1) Does oracle have any table which contain all the exceptions and it's code internally?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to run queries on external tables?
What is save point in oracle database?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
