这样行不行?
select name, salary, dept d from tb where salary > (select avg(salary) from tb where dept = d)
如果不行,可以用stored procedure.
select name, salary, dept d from tb where salary > (select avg(salary) from tb where dept = d)
如果不行,可以用stored procedure.