计算当前记录与下一条记录之间的天数差异

CREATE OR REPLACE VIEW v AS
SELECT '1' AS id, DATE '2015-1-1' AS hiredate FROM DUAL
UNION ALL
SELECT '2' AS id, DATE '2015-5-1' AS hiredate FROM DUAL
UNION ALL
SELECT '3' AS id, DATE '2015-3-1' AS hiredate FROM DUAL;

SELECT * FROM v;

SELECT id, hiredate, LEAD(hiredate) OVER(ORDER BY hiredate) AS next_hiredate FROM v;

SELECT id, hiredate, next_hiredate, next_hiredate - hiredate AS days_diff FROM (SELECT id, hiredate, LEAD(hiredate) OVER(ORDER BY hiredate) AS next_hiredate FROM v);

SELECT id, hiredate, LEAD(hiredate) OVER(ORDER BY hiredate) AS lead_hiredate, LAG(hiredate) OVER(ORDER BY hiredate) AS lag_hiredate FROM v;