Oracle: Simulate Lead Analytical Function (Manual Lead)

ORIGINAL QUERY

select
    deptno, empno, ename,
    lead(ename) over(partition by deptno order by ename) lead_emp
from scott.emp
order by deptno, ename

SIMULATED QUERY
select deptno, empno, ename,
(
    select ename from
    (
        select ename, deptno, rownum rn from
        (select empno, ename, deptno from scott.emp order by deptno, ename)
    ) a where a.rn = emp.rn + 1 and a.deptno=emp.deptno
) lead_emp
from (select empno, ename, deptno, rownum rn from (select * from scott.emp order by deptno, ename)) emp

OUTPUT
 






















Related Links:
- Oracle: Getting Simulated Cumulative Sum (Running Total)
- Oracle: Simulating Dense_Rank Analytical Functions (Manual Dense_Rank)
- Oracle: Simulating Rank Analytical Functions (Manual Rank)
- FIRST_VALUE and LAST_VALUE with Windowing Clause
- Oracle: Rank, Dense_Rank, Row_Number Analytic Functions
- LAG and LEAD - Analytic Function