select DNANE 部门,AVG(SALARY) 平均工资 FROM EMP,DEPT WHERE SALARY > 600 and EMP.DNO = DEPT.DNO GROUP BY DEPT.DNAME;
UPDATE (SELECT SALARY FROM EMP,DEPT WHERE SALARY < 600 AND EMP.DNO=DEPT.DNO AND DNAME = '销售部') SET SALARY = SALARY * 1.1;
b: update empt set salary = salary * 0.1 where salary < 600 and dno in (select dno from dept where dname = '销售部')
50,639
社区成员
85,638
社区内容
加载中
试试用AI创作助手写篇文章吧