Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of rank function?
- 1 Answers
- 6166 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 use of aggregate functions in oracle?
What are the attributes of the cursor?
What would you do with an in-doubt distributed transaction?
What are the logical operations?
Can I create users through internet explorer in oracle 10g?
Why do we need oracle client?
Why does for update in oracle 8 cause an ora-01002 error?
how to get second highest sal of emp table
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Explain an integrity constrains?
What happens if you use a wrong connect identifier?
Oracle General 
