select avg(SALARY) as SALARY,DEPT.DNAME from EMP
left join DEPT on DEPT.DNO = EMP.DNO where SALARY>=600 group by DEPT.DNAME update EMP set SALARY = SALARY * 1.1 where SALARY<600 and DNO in (select DNO from DEPT where DNAME = N'销售部')
left join DEPT on DEPT.DNO = EMP.DNO where SALARY>=600 group by DEPT.DNAME update EMP set SALARY = SALARY * 1.1 where SALARY<600 and DNO in (select DNO from DEPT where DNAME = N'销售部')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货