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 oracle the best database?

963

---

Explain the characteristics of oracle dba?

1120

---

How many types of tables are there in oracle?

1061

---

What is a cursor in oracle?

1173

---

What is memory advisor in Oracle?

1077

---

What is execute immediate in oracle?

1021

---

What are group functions in oracle?

1042

---

How to create id with auto_increment on oracle?

990

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2138

---

What is oracle rownum?

953

---

What is rich query?

983

---

How to create a new table in oracle?

1158

---

What is Reduced List of Values?

2167

---

How to use fetch statement in a loop?

1019

---

How to drop an index?

960

---