作业:###(1)获取员工的入职年份
(1)select ename,hiredate,left(hiredate,4)from emp;
(2)
(3)###(2)获取员工的入职工龄
(4)select ename,hiredate,2021-left(hiredate,4)from emp;
(5)
(6)
(7)select
(8) hiredate,2021-left(hiredate,4),
(9) case
(10) when 2021-left(hiredate,4)>40 then’’
(11) when 2021-left(hiredate,4)>39 then’’
(12) else '’
(13) end as dj
(14) from emp;
2021-04-08
最新推荐文章于 2021-11-10 17:26:45 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)