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