Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of rank function?
- 1 Answers
- 6269 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 |
Explain do view contain data?
What is the quickest way to fetch the data from a table?
what are the disadvantages of hierarchial database over RDBMS?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Difference between open_form and call_form in oracle.
What is a Private Synonyms ?
How to use in conditions in oracle?
What does a Control file Contain ?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
how do u setup a replication site?
how the indexes are stored in the Oracle Database?
how to retrieve daily sal from emp table in oracle 10g
Oracle General 
