what is the use of rank function?
- 1 Answers
- 5535 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 |
How to install oracle odbc drivers?
Please explain compound trigger in oracle?
how to handle exceptions in post production
Difference between inner join vs where ?
What is Private Database Link ?
What is the difference between SQL and SQL Server?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What is an oracle wallet?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Explain about achiever in sql?
What is data file?
how to find out largest value in a table
Oracle General 
