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

Question

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

Answer 1

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