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
What is varray?
How to drop an existing table in oracle?
What is object data modeling?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How can we find out the duplicate values in an oracle table?
What is Redo Log Buffer in Oracle?
How to export data with a field delimiter?
How to insert a record into a table?
How do I escape a reserved word in oracle?
What are the most common interview questions on ETL Testing for experience?
How to lock and unlock a user account in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is the difference between I and G in Oracle?
What is recovery manager in Oracle?
What are the different editions of oracle?
