求助

查整个表吗？
如果是的话
select *
from EMP

select
emptno,
AVG(salary) salary
into #temp
from employee
group by
emptno;
select
employeeno,
employeename,
employee.emptno
from employee
left join #temp on #temp.emptno=employee.emptno
where employee.salary>#temp.salary and employee.emptno =#temp.emptno