Databases Reference
In-Depth Information
16 , sal desc;
ENAME DEPTNO SAL RK DR RN
---------- ------- ---------- ---------- ---------- ----------
SCOTT 20 3000 1 1 1
FORD 20 3000 1 1 2
JONES 20 2975 3 2 3
ADAMS 20 1100 4 3 4
SMITH 20 800 5 4 5
Because analytic functions cannot be used in the
WHERE
clause (the inal predicate) of
a query, it's necessary to push the analytic function into an inline view to restrict the
inal result set to a regular top N, in this case a top 3 of the highest salaries.
