ANSIスタイルの構文：
SELECT empno, empname, job, sal,
LEAD (sal, 1, 0)
OVER (PARTITION BY job ORDER BY empno) AS sal_next
FROM emp
ORDER BY job, empno;
EMPNO EMPNAME JOB SAL SAL_NEXT
---------- ---------- --------- ---------- ----------
12 PAUL ANALYST ? 3000
13 GRACE ANALYST 3000 0
1 JOHN CLERK 800 950
2 ERIC CLERK 950 ?
3 KURT CLERK ? 1300
6 JULIE CLERK 1300 0
9 NICHOLAS MANAGER 2450 ?
10 NOVAK MANAGER ? 2850
11 ROGER MANAGER 2850 0
14 RICH PRESIDENT 5000 0
4 KENT SALESMAN 1250 ?
5 LYNN SALESMAN ? 1500
7 TERESA SALESMAN 1500 1600
8 MATTHEW SALESMAN 1600 0
Teradataスタイルの構文：:
SELECT empno, empname, job, sal,
LEAD (sal, 1, 0)
OVER (PARTITION BY job ORDER BY empno) AS sal_next
FROM emp
ORDER BY job, empno;
EMPNO EMPNAME JOB SAL SAL_NEXT
---------- ---------- --------- ---------- ----------
12 PAUL ANALYST ? 3000
13 GRACE ANALYST 3000 0
1 JOHN CLERK 800 950
2 ERIC CLERK 950 ?
3 KURT CLERK ? 1300
6 JULIE CLERK 1300 0
9 NICHOLAS MANAGER 2450 ?
10 NOVAK MANAGER ? 2850
11 ROGER MANAGER 2850 0
14 RICH PRESIDENT 5000 0
4 KENT SALESMAN 1250 ?
5 LYNN SALESMAN ? 1500
7 TERESA SALESMAN 1500 1600
8 MATTHEW SALESMAN 1600 0