Answer / shikha

The DENSE_RANK function computes the rank of a row in an
ordered group of rows.Rows with equal values for the
ranking criteria receive the same rank.

For eg.

To Show the set of sales people who make the top 3
salaries - that is, find the set of distinct salary
amounts, sort them, take the largest three, and give me
everyone who makes one of those values.

SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/

DEPTNO ENAME SAL TOPN
---------- ---------- ---------- ----------
10 KING 5000 1
CLARK 2450 2
MILLER 1300 3

20 SCOTT 3000 1 <--- ! (in
case of rank
JONES will have
3 and dense
rank will have 2)
FORD 3000 1 <--- !
JONES 2975 2
ADAMS 1100 3

30 BLAKE 2850 1
ALLEN 1600 2
30 TURNER 1500 3

Answer / nareshkumar

Dense Rank is used for assigning a precedence or rank to
each row in the result set relative to other rows in the
result set.

I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

39 Answers   TCS,

---

What is metrics?

2 Answers  

---

How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

1 Answers   TCS,

---

why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,

---

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

2 Answers   Accenture,

---

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,

---

How many universes are required for a single project,and how many reports are required for a single Universe.

2 Answers  

---

4.what is repository? types

8 Answers   TCS,

---

what is report tracing in bo

5 Answers   Satyam, TCS,

---

Explain the difference between compatible and incompatible objects?

0 Answers  

---

Explain in detail about type 2(scd),

0 Answers  

---

what is Scope of Analysis

8 Answers   TCS,

---