update语句的set后面不能有分组函数怎么解决？

update set sal=avg(sal) from emp where job='CLARK';
题为将emp表中job值为CLARK的员工的薪水改为所有员工的平均薪水

试试 update set sal = (select avg(sal) from emp) from emp where job = 'clark';

update emp set sal=(SELECT * FROM (SELECT avg(sal) from emp where job='CLARK')emp_1) where job='CLARK';

楼上方式可以，能试一试哈