select month,salary, lag(salary,1,null) over(order by month) lastsalary, lead(salary,1,null) over(order by month) nextsalary from a 这个可以有
SELECT MONTH,SALARY,LEAD(SALARY,1,SALARY)OVER(ORDER BY MONTH) LASTSALARY, LAG(SALARY,1,SALARY)OVER(ORDER BY MONTH) NEXTSALARY FROM( SELECT MONTH,SUM(SALARY) SALARY FROM T GROUP BY MONTH ) T1;
with a as ( select 2006 salary,6 month from dual union select 2007 salary,7 month from dual union select 2008 salary,8 month from dual ) select month,salary, lag(salary,1,null) over(order by month) lastsalary, lead(salary,1,null) over(order by month) nextsalary from a
lag(salary,1,null) lastsalary,
lead(salary,1,null)nextsalary
from a
lag(salary,1,null) over(order by month) lastsalary,
lead(salary,1,null) over(order by month) nextsalary
from a
这个可以有
SELECT MONTH,SALARY,LEAD(SALARY,1,SALARY)OVER(ORDER BY MONTH) LASTSALARY,
LAG(SALARY,1,SALARY)OVER(ORDER BY MONTH) NEXTSALARY
FROM( SELECT MONTH,SUM(SALARY) SALARY FROM T GROUP BY MONTH ) T1;
with a
as
(
select 2006 salary,6 month from dual
union select 2007 salary,7 month from dual
union select 2008 salary,8 month from dual
)
select month,salary,
lag(salary,1,null) over(order by month) lastsalary,
lead(salary,1,null) over(order by month) nextsalary
from a
错误提示:ORA-30484:丢失的此函数窗口说明!
我试了一下 4楼的很好,不过也谢谢你!