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;

What is a directory object?

0 Answers  

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

0 Answers  

---

What are the types of Database Links ?

2 Answers  

---

What is TNS File

7 Answers   Thermotech,

---

Explain about achiever in sql?

0 Answers  

---

Explain oracle data types with examples?

0 Answers  

---

How to get execution path reports on query statements?

0 Answers  

---

What are advantages of dateset in datastage?

0 Answers   iGate,

---

how to find full database size

1 Answers   BirlaSoft, Consultancy,

---

what is the dual table in oracle?

0 Answers  

---

How to use fetch statement in a loop?

0 Answers  

---

What are the database administrators utilities available?

0 Answers  

---