## 34、给任职日期超过30年的员工加薪10%. select empno from emp where (to_days(now())-to_days(hiredate))/365>30 错误的 ，更新时where 写不了子查询 update emp set sal=sal*1.1 where empno in( select empno from emp where (to_days(now())-to_days(hiredate))/365>30) update emp set sal=sal*1.1 where (to_days(now())-to_days(hiredate))/365>30