Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use RANK function ?

Hgnis-OracleMar 15 2012 — edited Mar 16 2012
Hello everyone,

here is the query I run in sql developer using RANKFunction.
SELECT Empno, Ename, Job, Mgr, Hiredate, Sal
FROM
(SELECT Empno, Ename, Job, Mgr, Hiredate, Sal,
*RANK*() OVER
(ORDER BY SAL Desc NULLS LAST) AS Emp_Rank
FROM Emp
ORDER BY SAL Desc NULLS LAST)
WHERE Emp_Rank < 6;
How I can use this query in my report in obiee or is there any replacement of RANK() function in obiee so that I can use that to get my same above result.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details