-- 前后函数 lag和lead
select
dname,
ename,
salary,
hiredate,
lag(hiredate,1,'2000-01-01') over(partition by dname order by hiredate)as time1,
lag(hiredate,2) over(partition by dname order by hiredate )as time2
from employee;
select
dname,
ename,
salary,
hiredate,
lead(hiredate,1,'2000-01-01') over(partition by dname order by hiredate)as time1,
lead(hiredate,2) over(partition by dname order by hiredate )as time2
from employee;
MYSQL 寒假自学 2022 十二 (十)
最新推荐文章于 2024-10-09 18:19:09 发布
本文介绍了SQL中的lag和lead函数,用于在数据分组后获取当前行之前或之后的值。示例中展示了如何在员工表中按部门和入职日期对员工进行分组,并获取每个员工上一个和下一个入职日期。这两个函数对于时间序列分析和数据透视非常有用。
摘要由CSDN通过智能技术生成